EXPDP / IMPDP for schemas and tables example

EXPDP/IMPDP for schemas in Oracle
1. Create the directory if not present.
create directory EXPDIR as 'D:\ORADUMP'

2. Run the EXPDP command for export of schema (HR,SCOTT).
EXPDP directory=EXPDIR dumpfile=schema.dmp logfile=schema_exp.log schemas=HR,SCOTT

Example of using the parameter file for EXPDP as follows:

--create parameter file for export of SCHEMAS(HR,SCOTT)
--notepad schema.par
dumpfile=schema.dmp
logfile=tables.log
directory=EXPDIR
schemas=HR,SCOTT
--Run the expdp
expdp parfile=schema.par


For impdp also use the similar command.
IMPDP directory=EXPDIR dumpfile=schema.dmp logfile=schema_imp.log schemas=HR,SCOTT

EXPDP/IMPDP for tables in Oracle
For EXPDP datapump:
1. Create the directory if not present.
create directory EXPDIR as 'D:\ORADUMP';

2. Export the multiple tables in command.
EXPDP directory=EXPDIR dumpfile=tables.dmp logfile=tables.log tables=HR.EMPLOYEE,HR.DEPT

For IMPDP datapump:
IMPDP directory=EXPDIR dumpfile=tables.dmp logfile=tables.log tables=HR.EMPLOYEE,HR.DEPT