Re: Oracle exp switch?

Hello, Roadrunner!
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
 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