|
-
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?
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
|