Data Pump has a very simple mechanism that can interact with many other interfaces such as, Oracle Enterprise Manager and custom interfaces, and it is basically made up of three unique parts; they are:
DBMS_DATAPUMPpackage, also known as the Data Pump API
DBMS_METADATApackage, also known as the Metadata API
As you can easily see in the following figure, the command-line interfaces,
impdp, uses the
DBMS_DATAPUMP package to execute the export and import operations using all the parameters passed in by the user in the command line. When metadata needs to be manipulated, it uses the
DBMS_METADATA package to extract, manipulate, and also to recreate the dictionary ...