The difference between Oracle Foundation (System Tools (Export,import)) Exp/imp and (data pump) EXPDP/IMPDP:

The difference of function between Exp/imp and EXPDP/IMPDP:

　　1, the user UserA to import the object into the UserB

Emp/imp usage:

Formuser=usera Touser=userb;

EMPDP/IMPDP usage:

Remap_schema= ' UserA ': ' UserB '

For example:

Imp system/password fromuser=usera touser=userb file=back.dmp log=backlog.log;

IMPDP system/password directory=expdp dumpfile=back.dmp remap_schema= ' UserA ': ' UserB ' Logfile=backlog.log

　　2. Change Table space

With Exp/imp, want to change table space, need to handle manually, such as ALTER TABLE XXX move tablespace_new such operations, but with IMPDP as long as:

Remap_tablespace= ' tablespace_old ': ' Tablespace_new '

　　

　　3. When making multiple tables

Exp/imp Usage: Tables (' table1 ', ' table2 ', ' table3 ')

EXPDP/IMPDP usage: tables= ' table1 ', ' table2 ', ' table3 '

　　4. Whether to export data rows

Exp rows=y, exporting data rows, rows=n not exporting data rows

EXPDP content (All: Object + data row, Data_only: Export only Object, Metadata_only: Only records that export data)

　　

The data pump technology proposed by oracle10g is superior to the Exp/imp command in the following ways:

　　1, the data Pump tool runs on the server side, compared to the client's exp/imp its performance is better, and can realize the full function of Exp/imp.

2. By using parameters such as exclude,include,content, the data pump can provide a finer level of selectivity for data and data objects.

3, by setting the database version number, the data pump can be compatible with the old version of the database system.

4, parallel execution.

5, through the estimate_only parameter, the data pump can estimate the disk space required for the export job.

6, support the distributed environment through the database connection implementation of import \ Export.

7, support the re-mapping function when importing (the object is imported into the new target data file, schema and tablespace, etc.).

8, support metadata compression and data sampling.

Auxiliary:http://blog.chinaunix.net/uid-16844439-id-3213672.html

The difference between Oracle Foundation (System Tools (Export,import)) Exp/imp and (data pump) EXPDP/IMPDP: