Re: Oracle exp switch?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 19 Jan 2002 11:09:48 -0800
Message-ID: <a2cg9s0ck2_at_drn.newsguy.com>


In article <D1j28.157$Ib.177299_at_typhoon.hawaii.rr.com>, "Hizzy says...
>
>I'm using the DOS shell in Windows 2000 not UNIX.
>

sorry for you..

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:612348047

has a method that works on most all platforms... including windows.

>"Igor Ushkalo" <igorus_at_protek.ru> wrote in message
>news:a2bguj$et6$1_at_news.sovam.com...
>> 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
>>
>>
>
>

--
Thomas Kyte (tkyte_at_us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp 
Received on Sat Jan 19 2002 - 20:09:48 CET

Original text of this message