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

All questions related to Control m monitoring tool

0 Answers   HCL, TY,


What is rdbms and its features?

0 Answers  


Can group by and ordered by used in a single query?

0 Answers  


What are the benefits of modeling?

0 Answers  


How do I create a database in access 2010?

0 Answers  






Which is the most used database?

0 Answers  


What do you understand by the view and mention the steps to create, update and drop a view?

0 Answers  


I need data on eBay customers in Chicago who can did bid on certain item? I dont have access to eBay database directly. How I get the information?

1 Answers   eBay, Google,


Explain what are the two types of oltp?

0 Answers  


What do you understand by data redundancy?

0 Answers  


What is data model in database?

0 Answers  


if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  


Categories