Export - using Parfile

[joyce_ank]

I cannot get export to run using a parfile. I've created 2 files

1. batch file
2. parfile

Batch file

rem echo on
rem cd\
rem c:

rem export does not work as a batch file with parfile still looking into this using second script in the meantime
rem exp userid=system/password parfile=u:\oracle\exports\fullexport.txt 1>>v:\backup\exports\fullexport.log
exp userid=system/password@evolvliv full=y grants=y rows=Y indexes=Y compress=Y constraints=Y file=u:\oracle\exports\evolvliv2.dmp


Parfile

FILE=evolvlivtest.dmp
FULL= Y
GRANTS = Y
INDEXES = Y
CONSTRAINTS=Y
ROWS = Y
COMPRESS = Y
LOG = V:\backup\exports\fullexport.log

It works fine when all parameters are specified on one line.
I'd also like the dmp file timestamped. Timestamping export file is more important to me than using the parfile. Any suggestions?

[Shestakov]

I know how it can works in unix (linux), but u use NT.

In unix:
1.
create template file like:
file=#DMP#.dmp
userid=
...
log=#DMP#.log
...

2.
start sh (bash) small script
tis script create export filename and replace #DMP# substring in template file to
new filename, that has date in name.
cat tpl_exp.par | sed -e s/#DMP#/d_$(date +%m%d%Y)/g > exp_parm.par
exp parfile=exp_pram.par

[joyce_ank]

Does anyone know how to do this in NT?

[hrishy]

Hello

Is this U:\ a local drive or a network drive ??

regards
Hrishy