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
When does checkpoint occur?
What is 2nf and 3nf?
How to handle data if f table are more than one and each table contain thousands of entries?
Which free database is best?
Explain the classification of Database Management System?
What do you mean by deadlock dbms?
Describe concurrency control.
Explain armstrong rules? How they are complete and/or sound?
Could you give me an example how, where I code checkpoint and restart. I need and example
Which is the best free database software?
Describe the difference between homogeneous and heterogeneous distributed database.
Describe the difference between embedded and dynamic sql.
What are the two types of indexes and explain them in detail?
What is a distributed database system?
Why is rdbms important?