Re: Export parfile variables

The problem is that in the parameter file %ORADATE% is a string, the command line knows that it is a variable by the paired % so it does the evaluation. Would the following work

EXP73 FILE=F:\EXPORTS\%ORADATE%.DMP LOG=F:\EXPORTS\%ORADATE%.LOG PARFILE=PFILE My PFILE reads:

USERID=user/password
CONSTRAINTS=N
GRANTS=N
INDEXES=N
TABLES=USER.TABLE
CONSISTENT=Y I think that you can combine the parameters on the command line and a PFILE. This will the command interpreter to evaluate the variable. John

riperez_at_compucom.com wrote in message <785i8t$40$1_at_nnrp1.dejanews.com>...
>I'm trying to automate Oracle 7.3 Exports on a Windows NT 4.0 Server. I
>would like the export file and log file to be named after the date on which
>they were created (01201999.DMP & .LOG). I found a way to set a variable
>under NT with the date format I want (by using the FOR command to parse the
>system date) but it doesn't seem to get passed to the EXP73.EXE command
line
>when it's reading my parfile.
>
>I have a batch file which runs:
>
>EXP73 PARFILE=PFILE
>
>My PFILE reads:
>
>USERID=user/password
>CONSTRAINTS=N
>FILE=F:\EXPORTS\%ORADATE%.DMP
>GRANTS=N
>INDEXES=N
>LOG=F:\EXPORTS\%ORADATE%.LOG
>TABLES=USER.TABLE
>CONSISTENT=Y
>
>When I use the "%ORADATE%" var within NT it works fine. Eg, C:\MD
%ORADATE%,
>it
>will create a dir called "01201999". But, when I try and use this in the
>parfile the closest it gets to working is literally naming the exp files:
>'%ORADATE%'.DMP & '%oradate%'.LOG
>
>Any help on this would be appreciated.
>
>Thanks
>Rich Perez
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Jan 27 1999 - 00:43:40 CST