Oracle Data Pump is a server-based infrastructure built into Oracle Database that enables high-speed, parallel loading and unloading of data and metadata. Introduced in Oracle Database 10g to replace the legacy exp and imp utilities, it serves as the foundation for database migrations, upgrades, and logical backups. Core Components Data Pump relies on three main components to function:
expdp (Data Pump Export): The command-line client used to extract data and metadata from a database into a set of OS files called dump files.
impdp (Data Pump Import): The command-line client used to load an existing dump file set into a target database.
PL/SQL Engine (DBMS_DATAPUMP & DBMS_METADATA): The server-side framework that does the heavy lifting. Because it runs completely on the server, jobs continue executing even if the client disconnects. Architecture & Mechanics
Unlike legacy utilities that processed data line-by-line over client connections, Data Pump executes operations inside the database instance using background worker processes. 1 Overview of Oracle Data Pump
Leave a Reply