Re: Oracle exp switch?

Then create a windows batch/cmd file to create a parfile in which your exp filename is generated dynamically. Use the parfile in your exp call.

"Hizzy X" <ironsteve_at_hawaii.rr.com> wrote in message news:D1j28.157$Ib.177299_at_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 - 19:45:08 CET