13. Extending Data Pump for Data and Object Migration

The Data Pump feature of the Oracle database is a high-speed, highly scalable mechanism for transferring data and objects from one database to another (using database links), from a database to a file (export), or from a file to a database (import). Data Pump uses direct-path loading and unloading technologies to improve performance.

Data Pump can be invoked using the following methods:

Image Exclusive Data Pump export and import tools, using expdp and impdp

Image PL/SQL code calling the DBMS_DATAPUMP

Get Oracle Database Problem Solving and Troubleshooting Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.