-
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?
-
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
-
Does anyone know how to do this in NT?
-
Hello
Is this U:\ a local drive or a network drive ??
regards
Hrishy
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|