Database Utilities (MOSC)

MOSC Banner

Datapump Changes Case of Supplied Parameter

edited Dec 28, 2012 5:28PM in Database Utilities (MOSC) 1 commentAnswered
When using datapump for nightly full exports, I get the datyofweek from command prompt thusly:

C:\> echo on

C:\>set PARSEARG="eol=; tokens=1,2,3,4* delims=/, "

C:\>for /F %PARSEARG% %i in ('DATE/T') do set DAYOFWEEK=%i

C:\>set DAYOFWEEK=Fri

This value is passed to datapump:

expdp.exe system/pwd@SID   DIRECTORY=expdp_dir DUMPFILE=SID_expfull_%DAYOFWEEK%.dmp  FULL=y LOGFILE=SID_expfull_%DAYOFWEEK%.log  REUSE_DUMPFILES=y

Even though the dumpfile file name is passed to expdp as MIXED case, when datapump creates the dumpfile, it converts the filename case to UPPER.  Please note that the logfile specification (also mixed case) is unaffected.

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