[egotah]

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

[Saurabh Sood]

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!!!

[egotah]

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.

[Saurabh Sood]

Hi,

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

Please write the command manually and check again.

[Saurabh Sood]

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

[Author]

Posts