what is datapump? Difference between exp and expdp?

Question Posted / syed.maxud@gmail.com

2 Answers
21657 Views
Capital IQ, TCS, WNS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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

1)what is the difference between view and materilized view? 2)what is the difference between delete and truncate? 3)what is the difference between migration and upgration? 4)what is the difference between RMAN HOT BACKUP and normal hot backup?

2 Answers 3i Infotech,

Difference between data and information, and how are they related in a database?

0 Answers Huawei,

What is the purpose of a database?

0 Answers

All questions related to Control m monitoring tool

0 Answers HCL, TY,

What are cursors give different types of cursors?

0 Answers

Describe the Process of Feature Engineering using SQL.

1 Answers

10 How to Handle Data Migration Between Different Databases?