Home » Infrastructure » Windows » export with dynamic file name (windows xp)
export with dynamic file name [message #472192] Thu, 19 August 2010 04:30 Go to next message
e303868
Messages: 4
Registered: June 2009
Junior Member
Hi everyone.
I want to know how export oracle tables with dynamic file name which contains (system date and database name) on windows XP platform.
bye.

[Updated on: Thu, 19 August 2010 05:19]

Report message to a moderator

Re: export with dynamic file name [message #472224 is a reply to message #472192] Thu, 19 August 2010 05:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Many examples in the Windows forum, just search for them.

Regards
Michel
Re: export with dynamic file name [message #472561 is a reply to message #472224] Sun, 22 August 2010 03:57 Go to previous messageGo to next message
e303868
Messages: 4
Registered: June 2009
Junior Member
Hi,
I searched in windows forum but I could not find a website solve my problem.
could you provide me a website which solve my problem please?
bye.
Re: export with dynamic file name [message #472563 is a reply to message #472561] Sun, 22 August 2010 04:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
C:\>echo %DATE%
22/08/2010

Regards
Michel
Re: export with dynamic file name [message #472565 is a reply to message #472563] Sun, 22 August 2010 04:41 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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

Previous Topic: oracle 10g installation problem in 2008 server
Next Topic: Gathering resource usage
Goto Forum:
  


Current Time: Thu Mar 28 15:15:31 CDT 2024