Tagged: dumpfile with dates
- This topic is empty.
13 May, 2010 at 8:05 pm #1922egotahParticipant
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..
15 May, 2010 at 12:10 pm #2110
You are using :
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:
17 May, 2010 at 2:06 pm #2111egotahParticipant
Thank you for the feedback, I have that and here is the error..
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
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.
** I just copied the command from your link **
Am running this from DOS prompt on windows and this is 10.2.0.3 release.
18 May, 2010 at 1:42 pm #2112
Do not copy-paste the command from link as the character ` will change.
Please write the command manually and check again.
20 May, 2010 at 9:34 am #2113
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.