what is datapump? Difference between exp and expdp?
Answers were Sorted based on User's Feedback
1. you can deattach or reattch datapump job.
2. you can parallelise datapump job [PARALLEL=4]
3. without export can do import using NETWORK_LINK parameter
4. can calculate export dump file size using ESIMATE_ONLY
5. expdp utility used which is caled by dbms_datapump
procudure
6. remapping capabilities during import
[REMAP_DATAFILE,EMAP_SCHEMA,REMAP_TABLESPACE,REUSE_DATAFILES
]
| Is This Answer Correct ? | 30 Yes | 7 No |
Answer / dba
Here you can see more details..
http://shonythomas.blogspot.in/2012/02/datapump-vs-expimp-difference-or.html
| Is This Answer Correct ? | 1 Yes | 1 No |
How is data stored in a relational database?
what is storage manager?
What are the steps involved in Database Startup ?
Explain fully functional dependency?
What are the SQL clauses supported in the link property sheet ?
What is database normalization? Explain types of it.
Explain the terms database and dbms. Also, mention the different types of dbms.
What is the main purpose of triggers in database?
Explain about the case statement present in stored procedure?
What is cold backup, hot backup, warm backup recovery?
What do you understand by correlated subqueries in dbms?
What is database management used for?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)