pass system date to export filename - Windows

[diwakar]

Hi,

Can anyone help me in passing the system day/date as a parameter to the export filename in the export command.

It is a windows environment and I need to pass the day and date in the filename of the export command dynamically.

Regards,

K.Diwakar

[stmontgo]

Originally posted by diwakar
Hi,

Can anyone help me in passing the system day/date as a parameter to the export filename in the export command.

It is a windows environment and I need to pass the day and date in the filename of the export command dynamically.

Regards,

K.Diwakar

quick and dirty but I simply pipe the dir listing to the export log file when the export completes

ie

dir c:\oradata\dump\prod.dmp >> c:\oradata\dump\prod.log

[DaPi]

Hey, we did this justa few days ago: http://www.dbasupport.com/forums/sho...threadid=45671

[akhadar]

u can create some Batch files which will add the sysdate to the dump file automatically.
1.First batch file
set today=Mon 12/06/2004
2.Second batch file
DATE /t >e:\foldername\setdate.txt

COPY e:\foldername\settoday.txt+e:\foldername\setdate.txt e:\foldername\firstbatchfile name

CALL e:\foldername\firstbatchfile name

SET today=%today: =%
SET today=%today:/=%

exp userid=username/password@connect string full=y file=e:\foldername\SID_%today%.dmp log=e:\foldername\SID_%today%.log

[diwakar]

Hi all,

Thanks for your response.

I feel that the command that I have used below is a lot more simpler :

exp system/ file=g:\indigo_%date:~0,3%_%date:~7,2%_%date:~10%.dmp log=g:\indigo_%date:~0,3%_%date:~7,2%_%date:~10%.log inctype=complete constraints=y direct=y compress=y


Regards,

K.Diwakar