Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle exp switch?

Re: Oracle exp switch?

From: Hizzy X <ironsteve_at_hawaii.rr.com>
Date: Sat, 19 Jan 2002 18:37:23 GMT
Message-ID: <D1j28.157$Ib.177299@typhoon.hawaii.rr.com>


I'm using the DOS shell in Windows 2000 not UNIX.

"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
>
>
Received on Sat Jan 19 2002 - 12:37:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US