what is datapump? Difference between exp and expdp?

Question Posted / syed.maxud@gmail.com

2 Answers
21826 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

What do you understand by correlated subqueries in dbms?

0 Answers

What is network database?

0 Answers

There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?

0 Answers

How many types of rdbms are there?

0 Answers

What is database users in dbms?

0 Answers

What are the different types of DBMS architecture?

0 Answers TCS,

How do databases help businesses?

0 Answers

What is the mechanism provided by ORACLE for table replication ?

1 Answers

What's the difference between clustered and non-clustered indexes?