📋Steps in this guide1/1

expdp/impdp with parallel option

-- Create the directory if not present create directory EXPDIR as '/export/home/oracle/ORADUMP'

oracle configurationintermediate

by OracleDba

13 views

expdp/impdp with parallel option

-- Create the directory if not present create directory EXPDIR as '/export/home/oracle/ORADUMP' -- Par file for export with parallel degree 4 -- Run expdp command

Code/Command (click line numbers to comment):

cat parfile=parallel.par
dumpfile=parallel_%U.dmp
logfile=tables.log
directory=EXPDIR
schemas=PROD_DATA
parallel=4
NOTE - mention parallel value as per cpu core.
expdp parfile=parallel.par
Same is the command for IMPDP.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!