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: