Oracle Data Pump

Oracle Data Pump — Short Description

Oracle Data Pump is Oracle’s high-speed utility for moving database data and metadata between databases, schemas, or tables using dump (.dmp) files.

It consists of:

expdp  → Export data to a .dmp file
impdp  → Import data from a .dmp file

Example:

DWH_N.DP_TEST_SOURCE
        │
        │ expdp
        ▼
dp_test_source.dmp
        │
        │ impdp
        ▼
ARMAN.DP_TEST_TARGET

A major advantage is that the destination does not need to have the same schema or table name:

REMAP_SCHEMA=DWH_N:ARMAN
REMAP_TABLE=DP_TEST_SOURCE:DP_TEST_TARGET

So Data Pump can move:

DWH_N.DP_TEST_SOURCE
        ↓
ARMAN.DP_TEST_TARGET

It can export/import complete databases, schemas, selected tables, metadata, or data, and supports options such as compression, filtering, parallel processing, and remapping objects during import.

Oracle Data Pump — Short Description

dump.sql

dump1.sql

dump_target.sql