Oracle 11g Release 1 (11.1) Data Pump Technology

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)

Data Pump ClientExpdpAndImpdpCall the Data Pump Export and Import utilities respectively.

Note:

Export utility by Data Pump (Expdp) Export the dump file and the original export tool (Exp) Exported files are not compatible. 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.

ExpdpAndImpdpThe client usesDBMS_DATAPUMP PL/SQLPackage to run the Export and Import commands. These parameters can be used to export and import data and metadata from all databases.

When metadata is moved, Data Pump usesDBMS_METADATA PL/SQLFunctions provided by the package.DBMS_METADATAThe package provides a centralized facility to extract, operate, and resubmit dictionary metadata.

DBMS_DATAPUMPAndDBMS_METADATAThe package can be used independently in 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:

• Data file Replication
• Direct path
• External tables
• 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 casesDirect pathOrExternal tables, Data Pump will not be able to load Data to a table. A table attribute conflict occurs. For example, if a table contains a LONG fieldDirect pathAccess Method), but there is a blockingDirect pathAccess conditions. 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 valueAPPENDOrTRUNCATEOfTABLE_EXISTS_ACTIONParameters.

 

References

• Oracle 11g Release 1 (11.1) Documents-Oracle Data Pump http://docs.oracle.com/cd/B28359_01/server.111/b28319/part_dp.htm#CEGJCCHC