Oracle DBA Blog

Full export using expdp export utility in Data Pump. Data pump in Oracle database is a server-based technology which enables very high-speed movement of data and metadata from one database to another. Component of Data pump in Oracle Database Data pump is made up of 3 components The Command-line clients, expdp and impdp The DBMS_DATAPUMP PL/SQL package ( a.k.a. Data Pump API ) The DBMS_METADATAPL/SQL package ( a.k.a. metadata API ) How Data pump works (Working of Data pump) The command-line client  expdp  and  impdp  use the procedures provided in the  DBMS_DATAPUMP  PL/SQL package to execute export and import commands using the parameters entered at the command line. Furthermore, these parameters enable the exporting and importing of data and metadata for a complete database or for subsets of a database.  Similarly, when metadata is moved, Data pump uses functionality provided by the  DBMS_METADATA  PL/SQL packa...