ORA-39124 with expdp when attaching timestamp to dumpfile name
Hi all,
I want to attach a timestamp to dumpfiles produced by expdp. So I did:
DUMPFILE=SCOTT_`date '+%d_%m_%y_%H:%M:%S'`.dmp.
I tried the command line, I tried a parfile all with the same result "ORA-39124: dump file name "SCOTT_"'`date '+%d_%m_%y_%H%M%S'`'".dmp" contains an invalid substitution variable" (same with logfile).
No matter what I escaped and where I did use whatever quotation marks it always stayed the same (frustrating).
I did it with renameing the files (e.g. SCOTT.dmp) with os means after exporting.
What must be done (if at all possible) to have expdp and impdp create/accept dumpfiles of the sort mentioned above?
Any help appreciated.
FJH