Home » RDBMS Server » Server Utilities » date in the export file name
date in the export file name [message #73619] Thu, 03 June 2004 03:48 Go to next message
swati lonkar
Messages: 1
Registered: June 2004
Junior Member
I have windows 2000 server with Oracle 8.1.7

I want to add current date in the export file name

e.g. exp03062004.dmp

for the export taken on 3 rd june 2004

Report message to a moderator

Re: date in the export file name [message #73621 is a reply to message #73619] Fri, 04 June 2004 04:14 Go to previous message
arun
Messages: 67
Registered: January 2000
Member
Hi,
Got some little info, hope it helps....

Make a global field, text result "gExport_File_Name".

Make a script:

Set Field [[gExport_File_Name, "File Name " & DateToText (Status (Current Date))]]
Copy [[Select, gExport_File_Name]]
Export Records [[Restore, No dialog]]

Regards
Arun

Report message to a moderator

Previous Topic: Not able to export
Next Topic: Full Import - Quick Question
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 13:06:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.