expdp/impdp with parallel option - Oracle Database Script. -- Create the directory if not present create directory EXPDIR as '/export/home/oracle/ORADUMP' -- Par file for export with parallel degree 4 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. -- Run expdp command expdp parfile=parallel.par Same is the command for IMPDP.
-- Create the directory if not present create directory EXPDIR as '/export/home/oracle/ORADUMP' -- Par file for export with parallel degree 4 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. -- Run expdp command expdp parfile=parallel.par Same is the command for IMPDP.