Database Utilities (MOSC)

MOSC Banner

Run datapump command with date timestamp and parallel parameter

edited May 25, 2020 8:48AM in Database Utilities (MOSC) 3 commentsAnswered

I am trying to create a datapump expdp script with timpestamp and parallel parameter as below.

set currentdate=%date:~10,4%%date:~7,2%%date:~4,2%%time:~0,2%%time:~3,2%

set currentdate=%currentdate: =%

expdp ECHO/ECHO@prfecho dumpfile=ECHO_%currentdate%_%U.dmp parallel=4 LOGFILE=ECHO_%currentdate%.log DIRECTORY=DIRECTORY_ECHO

Unfortunately the dump job isnt producing 4 dump files as dumpfile is being produced as below


ECHO_201620061559_CURRENTDATE


Kindly assist.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center