EXPDP & IMPDP use parallel option for faster in Oracle

EXPDP & IMPDP use parallel option for faster in Oracle

Dumpfile parameter you need to specify the name with %U for generating the dumpfile with sequence number 01 to 99.

expdp scott/tiger@orcl schemas=SCOTT directory=TEST_DIR parallel=4 dumpfile=SCOTT_%U.dmp logfile=expdpSCOTT.log

impdp scott/tiger@orcl schemas=SCOTT directory=TEST_DIR parallel=4 dumpfile=SCOTT_%U.dmp logfile=impdpSCOTT.log

From Oracle 12.2 additional thing is used
%U is specify from 01 to 99. It is used as old version it is supported.
%L,%l is used from 01-99 also extend up to 2147483646.

Substitute parameter also included

%d, %D : The current day of the month in DD format.
%m, %M : The current month in MM format.
%y, %Y : The current year in YYYY format.
%t, %T : The current date in YYYYMMDD format.

If you used this substitute value in older version then you get the following error:
ORA-39124: dump file name “SCOTT_%T.dmp” contains an invalid substitution variable

Example:

expdp scott/tiger@xe schemas=SCOTT directory=TEST_DIR dumpfile=SCOTT_%T.dmp logfile=expdpSCOTT.log
Export: Release 11.2.0.2.0 - Production on Sat Dec 8 15:46:29 2018
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39124: dump file name "SCOTT_%T.dmp" contains an invalid substitution variable

Advertisements

One thought on “EXPDP & IMPDP use parallel option for faster in Oracle

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.