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

Define identity and uniqueidentifier property of column?

626


Explain the three Level Architecture of the Database System

609


What are the main functions of a database management system?

564


Why is database important?

592


What versions of clipper does netlib support?

585






What are the types of distributed database?

578


Mention some disadvantages of query?

611


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?

1882


What is Schema in DBMS?

647


What are the components of a database management system?

535


What is progress apama?

622


Explain the term generalization.

587


What is a candidate key in dbms?

582


Define scalar functions.

623


What is a database in healthcare?

587