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
Define identity and uniqueidentifier property of column?
Explain the three Level Architecture of the Database System
What are the main functions of a database management system?
Why is database important?
What versions of clipper does netlib support?
What are the types of distributed database?
Mention some disadvantages of query?
1)How to check tablespace utilization? 2)what are the RMAN CLONING STEPS? 3)what is standby database? 4)what is difference between standalone database and target database? 5)How to backup the standalone database? 6)tell about the ubgrade steps? 7)How to apply the pathes?
What is Schema in DBMS?
What are the components of a database management system?
What is progress apama?
Explain the term generalization.
What is a candidate key in dbms?
Define scalar functions.
What is a database in healthcare?