Datapump dumpfile with dates

This topic contains 4 replies, has 0 voices, and was last updated by  egotah 9 years, 4 months ago.

  • Author
    Posts
  • #1922

    egotah
    Participant

    Can some one direct me how to generate Datapump Export Dump with Dumpfile name Containing Current Date and Time.

    I tried this format with error..

    dumpfile=myexport-date '+%d%m%Y_%H%M%S'.dmp

    logfile=myexport-date '+%d%m%Y_%H%M%S'.log

  • #2110

    Saurabh Sood
    Member

    Hi,

    You are using :

    date ‘+%d%m%Y_%H%M%S’

    but you have to put the ` sign before the “date” and end with the same after S’.

    You can refer to following link for the details:

    http://askdba.org/weblog/2009/06/generating-datapump-export-dump-with-dumpfilename-containing-current-date-and-time/

    Cheers!!!

  • #2111

    egotah
    Participant

    Thank you for the feedback, I have that and here is the error..

    E:backupomahalead>expdp parfile=ftp.par

    Export: Release 10.2.0.1.0 – Production on Monday, 17 May, 2010 8:58:26

    Copyright (c) 2003, 2005, Oracle. All rights reserved.

    Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – Produc

    tion

    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    ORA-39001: invalid argument value

    ORA-39000: bad dump file specification

    ORA-39124: dump file name “æ+%d%m%y_%H%M%SÆ`.dmp” contains an invalid substitution variable

    LRM-00113:multiple values not allowed for parameter ‘logfile’

    Here is the command.. from the parfile.

    schemas=(FTP_USER,FTP_SOIL,FTP_PAINT,D_NEPA,BVCONNECT,SERAPEUM,RES_LEAD,RL_FTP,SWAMP)

    DIRECTORY=datapump_dir

    dumpfile=FTP_SRRL-date+%d%m%y_%H%M%S.dmp

    logfile=ftp_SRRL- ‘date +%d%m%y_%H%M%S`.LOG

    job_name=ftp_expdp

    keep_master=N

    ** I just copied the command from your link **

    Am running this from DOS prompt on windows and this is 10.2.0.3 release.

  • #2112

    Saurabh Sood
    Member

    Hi,

    Do not copy-paste the command from link as the character ` will change.

    Please write the command manually and check again.

  • #2113

    Saurabh Sood
    Member

    Hi,

    As you mentioned earlier, and that i missed….. You are using this on windows ..

    The syntax which I have mentioned is not for windows but will work only for unix platforms only..

You must be logged in to reply to this topic.