Datapump dumpfile with dates (5 posts)
About This Topic
- Posted 1 year ago
- By egotah
- Latest reply from Saurabh Sood
- This topic is
not resolved - RSS feed for this topic
Tags
-
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 -
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:
Cheers!!!
Saurabh Sood
Senior Consultant:DBA Services -
Thank you for the feedback, I have that and here is the error..
E:\backup\omahalead>expdp parfile=ftp.parExport: 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. -
Hi,
Do not copy-paste the command from link as the character ` will change.
Please write the command manually and check again. -
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..
Reply
You must log in to post.