Dear all,
my question is how do I add the full timestamp, or at least the date YYYYMMDD, in the file name of the dump file which I export every day by the expdp tool?
expdp 'sys/*******@mydadabase as sysdba' schemas=abcdefg flashback_time=systimestamp DIRECTORY=DAILY_DUMP_DIR DUMPFILE=daily_dump_export.dmp logfile=daily_dump_export.log
I would like to have file names like e.g. mydump_20180222.dmp
Oracle is 11.2 and Windows server.
Thx in advance