EXPDP / IMPDP for schemas and tables example

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.