Oracle11gRelease1 (11.1) DataPump Technology

OracleDataPump technology allows you to quickly move data and metadata from one database to another. Expdp and impdp customers

Oracle Data Pump technology allows you to quickly move Data and metadata from one database to another. Expdp and impdp customers

Content

Oracle Data Pump technology allows you to quickly move Data and metadata from one database to another.

Data Pump Component

How to move Data Pump

References

Data Pump Component

Oracle Data Pump consists of three different parts:

Command Line client expdp and impdp

DBMS_DATAPUMP PL/SQL package (also called Data Pump API)

DBMS_METADATA PL/SQL package (also called Metadata API)

The Data Pump client expdp and impdp call the Data Pump Export and Import utility respectively.

Note:

The dump file exported by the Data Pump export utility (expdp) is not compatible with the file exported by the original export tool (exp. Therefore, files generated by the exp tool cannot be imported using the impdp tool.

In most cases, we recommend that you use the Data Pump Export and Import utilities in Oracle. Compared with the original export/import tools, they provide stronger data movement performance.

The expdp and impdp client run the Export and Import commands by using the stored procedure provided by DBMS_DATAPUMP PL/SQL package in the command line input parameters. These parameters can be used to export and import data and metadata from all databases.

When metadata is moved, Data Pump uses the features provided by DBMS_METADATA PL/SQL package. The DBMS_METADATA Package provides a centralized facility to extract, operate, and resubmit dictionary metadata.

The DBMS_DATAPUMP and DBMS_METADATA packages can be used independently on the command line.

Note:

All Data Pump export and import processes, including read and write dump files, are completed on your specified database. Therefore, if you do not have the permission, the DBA must create a read/write directory object for the Data Pump file on the file system of the server. Users with permissions can use a default directory object.

How to move Data Pump

Data Pump uses four mechanisms to move Data. Sort by moving speed in ascending order, as shown below:

Direct path

Database link Import

Note:

Data Pump does not load tables that disable the unique index. If data is loaded to these tables, you must delete or enable indexes.

Note:

In some cases, Data Pump cannot load Data into a table using direct path or external tables. A table attribute conflict occurs. For example, if a table contains a LONG field (which requires the direct path access method), but there is a condition that prevents direct path access. At this point, a ORA-39242 error occurs. To solve this problem, create a table with the LOB column before importing. In this way, you can execute the import and use the TABLE_EXISTS_ACTION parameter with the value of APPEND or TRUNCATE.

References

Oracle 11g Release 1 (11.1) Documents-Oracle Data Pump