4 Replies Latest reply: Jul 12, 2012 12:48 PM by user13312943 RSS

    How to append date in YYYYMMDD format in .par file for export

    user13312943
      Hi,
      Database Version: 10.2.0.4
      OS: AIX

      I have an export script which reads .par file and executes "exp" to export schema.
      I would like to add date in "YYYYMMDD" format for the dump file like this

      owner=scott file=/exports/scott_${`date '+%Y%m%d'`}.dmp feedback=10000

      I know above statement will not help, but I am giving it as example on what I want to achieve.

      I want the file name as =/exports/scott_20120712.dmp

      Thanks
      Sarayu