what is datapump? Difference between exp and expdp?

Answers were Sorted based on User's Feedback



what is datapump? Difference between exp and expdp?..

Answer / aanand shirodkar

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

what is datapump? Difference between exp and expdp?..

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

Post New Answer

More Database Management Interview Questions

What is difference between database and file?

0 Answers  


What is second normal form?

0 Answers  


How do you organize a database?

0 Answers  


What do you understand by data redundancy?

0 Answers  


What is a candidate key in dbms?

0 Answers  






What is stored in a database?

0 Answers  


How do you exit a database?

0 Answers  


What is unique key example?

0 Answers  


What is the main difference between union and union all?

0 Answers  


What are the types of database management system?

0 Answers  


What is default value database?

0 Answers  


What do you mean by entity type?

0 Answers  


Categories