1. Cloud Control Database Lifecycle Management Administrator's Guide
  2. Database Migration
  3. Plan Your Migration
  4. Supported Migration Methods
  5. Data Pump

Data Pump

Data Pump provides an Export and Import way of moving data and metadata from one database to another. It begins the Export by unloading table data, database object metadata, and control information into a file dump. During the Import portion, the file dump is loaded into the destination database. Some of its main benefits include metadata filtering based upon object and object types, you can specify how partitioned tables are handled during import operations, as well as a full range of data types that can be exported and imported.

Data Pump supports the following modes in Database Migration Workbench for loading and unloading portions of the database to be migrated:
  • Full Database Mode: In this mode, the entire content of the source database is moved to the File Dump and loaded into the target database.
  • Schema Mode: In this mode, only objects owned by the specified schema are moved to the File Dump and later loaded.

For more information on Data Pump see: Oracle Data Pump in Oracle Database Utilities 19c. If your database version is not 19c, look for the corresponding Data Pump section within your database version documentation.