what is datapump? Difference between exp and expdp?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1416


What is database host?

517


How to specify transaction or query timeout?

542


Write a query to create a duplicate table with and without data present?

460


Is there an example how to configure externalfileaccess setting in firebird.conf?

474






Explain data dictionary.

524


Why do we need database normalization?

492


What do you understand by cursor? Mention the different types of cursor?

468


Define database system.

566


Explain the Normalized Relations?

2305


Explain entity, entity type, and entity set in dbms?

465


What is limit in dbms?

479


What is the purpose of a field in a database?

458


Describe the difference between homogeneous and heterogeneous distributed database.

511


What are the four objects in a database?

507