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
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
What is database host?
How to specify transaction or query timeout?
Write a query to create a duplicate table with and without data present?
Is there an example how to configure externalfileaccess setting in firebird.conf?
Explain data dictionary.
Why do we need database normalization?
What do you understand by cursor? Mention the different types of cursor?
Define database system.
Explain the Normalized Relations?
Explain entity, entity type, and entity set in dbms?
What is limit in dbms?
What is the purpose of a field in a database?
Describe the difference between homogeneous and heterogeneous distributed database.
What are the four objects in a database?