|
|
|
|
|
|
|
|
| Re: export with dynamic file name [message #472565 is a reply to message #472563] |
Sun, 22 August 2010 04:41   |
e303868
Messages: 4
Registered: June 2009
|
Junior Member |
|
|
Hi
I take export to dept table using the following:-
exp scott/tiger file=%DATE%.dmp tables=dept
but the name of the file looks like that:-
Sun.DMP
only day was displayed but I need to display day and date together or date only.
I need the file name likes:-
Sun 08/22/2010
or
08/22/2010
bye
[Updated on: Sun, 22 August 2010 04:43] Report message to a moderator |
|
|
|
| Re: export with dynamic file name [message #472567 is a reply to message #472565] |
Sun, 22 August 2010 06:03 |
 |
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
If you have the day then you are not in windows XP but in Windows Y2K or Y2K3
You can format the date how you want using something like the following:
C:\>for /F "tokens=1-3 delims=/ " %A in ('date/t') do set MYDATE=%C%B%A
C:\>set MYDATE=20100822
C:\>echo %MYDATE%
20100822
In a cmd script you have to double the %, for you, with day name, token are 2-4.
These are Windows questions and not Oracle one.
Regards
Michel
[Updated on: Sun, 22 August 2010 06:03] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
