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 |
What is 1nf 2nf 3nf in dbms?
Mention the types of join?
What is 1nf?
why an information gap exists in most organizations.
Why does reading require write privileges on database file?
What are the different levels of abstraction in the dbms?
What do you mean by buffer manager?
Give us a non-computer example of preemptive and non-preemptive scheduling?
How to create student table through query with a numeric column of ID and Name of Chaeacter and D-O-B with date type in database What will be the query for this purpose?
Define database lock?
Why do not you use gnu autoconf or scons for building?
What is system r?
Oracle (3253)
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)