Urgent (Script ) [message #124811] |
Tue, 21 June 2005 11:30 |
rudolfguth
Messages: 2 Registered: June 2005
|
Junior Member |
|
|
Hi,
Thank you for answer me... But I need the scriptso I can set a time and date to start the Oracle 9 backup... If anyone know anything about this script please send it to me!!!!
Thank You again..
|
|
|
Re: Urgent (Script ) [message #124813 is a reply to message #124811] |
Tue, 21 June 2005 11:42 |
rsone
Messages: 7 Registered: June 2005 Location: Jacksonville
|
Junior Member |
|
|
To have current Date and time appended to your backup file you can have spool file file for your backup log which can be showed as filename with Date and Time to track Date and Time.
Here is how you do it
column filedate new_value filedate noprint;
select to_char(sysdate,'yyyymmddhh24miss') filedate from dual;
spool <urspoolfilename>&filedate..log
Can you try this method?
|
|
|
|