1 Reply Latest reply: Apr 4, 2013 7:39 AM by Srini Chavali-Oracle RSS

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

    Sivaprasad S
      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.