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 meant by a database?

0 Answers  


What do you mean by checkpoints in dbms?

0 Answers  


What are the advantages of database system?

0 Answers  


What is difference between database and file?

0 Answers  


What is type of end users?

0 Answers  






Explain degree of a relation?

0 Answers  


Enlist some commands of dml?

0 Answers  


What are foreign keys in database?

0 Answers  


What is the role of database management system?

0 Answers  


Why do I need netlib?

0 Answers  


What is a database management system and give examples?

0 Answers  


What do you mean by deadlock dbms?

0 Answers  


Categories