📋Steps in this guide1/1

expdp/impdp for schemas

-- Create the directory if not present

oracle configurationintermediate

by OracleDba

14 views

expdp/impdp for schemas

-- Create the directory if not present -- Par file for export of SCHEMAS(PROD_DATA,DEV_DATA) -- Run expdp

Code/Command (click line numbers to comment):

create directory EXPDIR as '/export/home/oracle/ORADUMP'
cat parfile=schema.par
dumpfile=schema.dmp
logfile=tables.log
directory=EXPDIR
schemas=PROD_DATA,
DEV_DATA
expdp parfile=schema.par
For impdp also use the similar command.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!