Re: Oracle exp switch?
From: Igor Ushkalo <igorus_at_protek.ru>
Date: Sat, 19 Jan 2002 13:14:34 +0300
Message-ID: <a2bguj$et6$1_at_news.sovam.com>
Date: Sat, 19 Jan 2002 13:14:34 +0300
Message-ID: <a2bguj$et6$1_at_news.sovam.com>
Hello, Roadrunner!
[Quoted] You wrote on Sat, 19 Jan 2002 10:02:54 GMT:
R> I'm using the Oracle "exp" command to do an export to a export file. R> Does anyone know if their is a way I can stamp the time and date into [Quoted] R> the filename of the export file?
DATE_OF_EXPORT=`date | awk '{print $01 $02 $03 $04}'` exp .... FILE=$ORACLE_SID$DATE_OF_EXPORT.dmp ....
You can do everything via UNIX shell B-)
R> or R> Does the exp command have a switch that will not overwrite an R> existing export file of the same name?
Try to delete it before export from batch script....
- Best regards, Igor Ushkalo (igorus!) - igorus(at)mail.ru, ICQ #19972198