-
I've got a batch file to do an export which relies on a parfile. But this does not seem to work. It only generates a log file but does not do the export.
Parfile
FULL= Y
GRANTS = Y
INDEXES = Y
CONSTRAINTS=Y
ROWS = Y
COMPRESS = Y
fullexport.txt=FILE=v:\backup\exports\evolvlivtest.dmp
LOG = V:\backup\exports\fullexport.log
Batch file
echo on
cd\
c:
exp system/evolvliv@evolvliv parfile=u:\oracle\exports\fullexport.txt 1>>v:\backup\exports\fullexport.log
rem exp userid=system/password@evolvliv full=y grants=y rows=Y constraints=Y file=u:\oracle\exports\evolvlivtest.dmp
Its seems to work when all the parameters are specified in one file.
-
FULL= Y
GRANTS = Y
INDEXES = Y
CONSTRAINTS=Y
ROWS = Y
COMPRESS = Y
fullexport.txt=FILE=v:\backup\exports\evolvlivtest.dmp
LOG = V:\backup\exports\fullexport.log
Looks like the export is on WinNT. The file parm usage is
FILE=v:\backup\exports\evolvlivtest.dmp and not as you have shown. Check that upi and then run. If it doesnt come back. We shall go from there.
-
Still doesn't work. What's upi?
-
It was just a typo. What I meant was this "Check that up and then run. If it doesnt, then come back"
I will try to look into it and post the reply back.
-
Well still doesn't run. Will await your reply
-
Try it out clearly ,it will work well
Saran OCP 8i DBA
-
What do you mean by try it out clearly.
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
|