Oracle Datapump table import/export for Oracle Database

Procedure :


1. Create the database user

SQL > sqlplus / as sysdba
SQL > Alter User john Identified  By penguin Account Unlock;

2. Create the alias for the import/export directory

root > mkdir /oracle/PUP/export_table
root > chown oracle:oinstall export_table
root > chmod 775 export_table
SQL > CREATE OR REPLACE DIRECTORY export_table AS '/oracle/PUP/sapdata1/exp_table';
SQL > GRANT READ, WRITE ON DIRECTORY export_table TO john;



3. Export / import the table using below command

Table Export:

root > expdp john/penguin@PUP tables="SAPSR3".CCCFLOW directory=export_table dumpfile=CCCFLOW.dmp logfile=expdpCCCFLOW.log;

Table Import:

root > impdp john/penguin@PUP tables="SAPSR3".CCCFLOW directory=export_table dumpfile=CCCFLOW.dmp logfile=impdpCCCFLOW.log;

Note :
Always make sure while taking the export no sql connection or user connection are available