Data Pump Export and import Commands with examples

cd /u01/app/TEST_DIR
mkdir test_dir


conn sqlplus '/as sysdba'

CREATE  DIRECTORY test_dir AS '/u01/app/TEST_DIR/';
GRANT READ, WRITE ON DIRECTORY test_dir TO system;

Particular table
=================
expdp test/test@testdb tables=kmi directory=TEST_DIR dumpfile=kmi_180216.dmp logfile=kmi_180216.log


impdp test/test@testdb directory=TEST_DIR dumpfile=kmi_180216.dmp logfile=imp_kmi_180216.log remap_schema=test:test1


or

impdp testone/testone@testdb directory=TEST_DIR dumpfile=kmi_180216.dmp logfile=imp_kmi_180216.log remap_schema=test:test1


Full Schema
========


expdp system/manager schemas=test directory=TEST_DIR dumpfile=exp_test_full_180216.dmp logfile=exp_test_full_180216.log


impdpsystem/manager schemas=SCOTT directory=TEST_DIR dumpfile=exp_test_full_180216.dmp logfile=imp_test_full_180216.log remap_schema=test:test1



EXCLUDE/INCLUDE
================

single table
*************
expdp system/manager schemas=test   DIRECTORY=TEST_DIR DUMPFILE=exp_test_full_180216.dmp logfile=exp_test_full_180216.log   exclude=table:"IN('EMPLOYEE')"

Two tables
**********

expdp system/manager schemas=test   DIRECTORY=TEST_DIR DUMPFILE=exp_test_full_180216.dmp logfile=exp_test_full_180216.log  exclude=table:"in\('EMPLOYEE'\,'ATTENDANCE'\)"

Only procedure/triggers/funcion/type/dblinks
***********************************************

expdp system/manager schemas=test   DIRECTORY=TEST_DIR  dumpfile=exp_test_full_180216.dmp  logfile=exp_test_full_180216.log exclude=table


impdp system/manager   directory=TEST_DIR dumpfile=exp_test_full_180216.dmp logfile=imp_test_full_180216.log remap_schema=test:test1