Exporting and importing dmp file in oracle database 12c

Exporting dmp file

Exporting dmp file of a schema using system user:

Syntax:

expdp system/Admin123@pdborcl schemas=HR directory=DPUMP_DIR dumpfile=hr.dmp logfile=expdpHR.log

Creating a directory object for oracle dump:

Syntax:

SQL> CREATE or REPLACE DIRECTORY dpump_dir as ' C:\app\BIASADMIN\oradata\orcl\pdborcl’;

To enable user hr to have access to these directory objects, you would assign the necessary privileges, for example:

SQL> GRANT READ, WRITE ON DIRECTORY dpump_dir TO hr;

Use the following Data Pump Export command

Exporting dmp file of a schema using itself:

Syntax:

expdp hr/hr@pdborcl directory=DPUMP_DIR dumpfile=HR1.dmp logfile=HR1.log full=yes

Importing dmp file

Importing dmp file of a schema using system user:

Syntax:

impdp system/Admin123@pdborcl schemas=HR directory=DPUMP_DIR dumpfile=HR.dmp logfile=impdpHR.log

Importing dmp file of a schema using itself:

Syntax:

impdp hr/hr@pdborcl directory=DPUMP_DIR dumpfile=HR2.dmp logfile=HR2.log