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

Source: Internet
Author: User

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:

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.