I cannot get export to run using a parfile. I've created 2 files
1. batch file
rem echo on
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
GRANTS = Y
INDEXES = 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?
I know how it can works in unix (linux), but u use NT.
create template file like:
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
Does anyone know how to do this in NT?
Is this U:\ a local drive or a network drive ??
Click Here to Expand Forum to Full Width