📋Steps in this guide1/1

expdp/impdp for TABLES

-- Create the directory if not present

oracle configurationintermediate

by OracleDba

13 views

expdp/impdp for TABLES

-- Create the directory if not present --- Par file for export of multiple tables -- Run expdp command

Code/Command (click line numbers to comment):

create directory EXPDIR as '/export/home/oracle/ORADUMP'
cat parfile=tables.par
dumpfile=tables.dmp
logfile=tables.log
directory=EXPDIR
tables=PROD_DATA.EMPLOYEE,
PROD_DATA.DEPT,
DEV_DATA.STAGING
expdp parfile=tables.par

Comments (0)

Please to add comments

No comments yet. Be the first to comment!