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

Report message to a moderator

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: 4267
Registered: February 2005
Location: East Coast USA
Senior Member
After the export, do:

mv {yourfile} exp`date '+%Y%m%d'`.dmp

Report message to a moderator

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

Report message to a moderator

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: 20109
Registered: January 2009
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.

Report message to a moderator

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: 54247
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

Report message to a moderator

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: 16998
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Code provided here might help.

Report message to a moderator

Previous Topic: Connect Microsoft Access Database with Oracle 9i Database
Next Topic: Connect SQL server2005 with Forms6i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 25 16:47:21 CDT 2013

Total time taken to generate the page: 1.01870 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.