This discussion is archived
1 Reply Latest reply: Apr 4, 2013 5:39 AM by Srini Chavali-Oracle RSS

How to have date and time stamp on dump & log file using EXPDP PAR fle?

Sivaprasad S Newbie
Currently Being Moderated
Environmnet:

O.S Version     HP-UX B.11.31 U ia64
Oracle DB Version     11.2.0.3.0 , Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

Requirement:

Like to have date and time stamp on dump file and log file generated using EXPDP with PAR parameter file

Sample Code, which I use:
--- PAR File: expdp_sivaDB_full.par

USERID=system@sivaDB
DIRECTORY=EXPDP_DIR
DUMPFILE=expdp_sivaDB_full_20130317.dmp
LOGFILE=expdp_sivaDB_full_20130317.log
SCHEMAS=HR, ORDER
COMPRESSION=ALL
CLUSTER=N
VERSION=LATEST
PARALLEL=4
Execution:
oracle@dbhost.com:/exports $ expdp parfile= expdp_sivaDB_full.par
I would like to have current date and time stamp as suffix on the dump file name and log file name.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points