Home » Infrastructure » Windows » Setting datestamp on export file (oracle10g 10.2.0.3)
Setting datestamp on export file [message #395119] Tue, 31 March 2009 06:39 Go to next message
vags76
Messages: 12
Registered: February 2009
Junior Member
Hi all,
What I am trying to do is set date on every daily produced exp*.dmp file. Thus, today's export file should be exp20090331.dmp, tomorrows will be exp20090401.dmp etc etc. Anyone has an idea how to settle that??

Regards
Re: Setting datestamp on export file [message #395139 is a reply to message #395119] Tue, 31 March 2009 08:09 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
After the export, do:

mv {yourfile} exp`date '+%Y%m%d'`.dmp
Re: Setting datestamp on export file [message #395155 is a reply to message #395139] Tue, 31 March 2009 08:46 Go to previous messageGo to next message
vags76
Messages: 12
Registered: February 2009
Junior Member
and how could that be set on windows. U have an idea???
thanx for your reply anyway.
regards
Re: Setting datestamp on export file [message #395160 is a reply to message #395119] Tue, 31 March 2009 08:56 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>and how could that be set on windows. U have an idea???
U is not a member of this forum.
This is a FAQ & answer can be found on this forum.
Re: Setting datestamp on export file [message #395164 is a reply to message #395155] Tue, 31 March 2009 09:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Answered many times in Windows forum to which I move your topic.

Regards
Michel
Re: Setting datestamp on export file [message #395497 is a reply to message #395155] Wed, 01 April 2009 11:55 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Code provided here might help.
Previous Topic: Connect Microsoft Access Database with Oracle 9i Database
Next Topic: Connect SQL server2005 with Forms6i
Goto Forum:
  


Current Time: Fri Mar 29 03:43:06 CDT 2024