Export - batch file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Export - batch file

Hybrid View

  1. #1
    Join Date
    Oct 2001
    Location
    Hornchurch, Essex UK
    Posts
    132
    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.

  2. #2
    Join Date
    May 2001
    Posts
    57
    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.

  3. #3
    Join Date
    Oct 2001
    Location
    Hornchurch, Essex UK
    Posts
    132
    Still doesn't work. What's upi?

  4. #4
    Join Date
    May 2001
    Posts
    57
    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.

  5. #5
    Join Date
    Oct 2001
    Location
    Hornchurch, Essex UK
    Posts
    132
    Well still doesn't run. Will await your reply

  6. #6
    Join Date
    Apr 2002
    Posts
    13
    Try it out clearly ,it will work well
    Saran OCP 8i DBA

  7. #7
    Join Date
    Oct 2001
    Location
    Hornchurch, Essex UK
    Posts
    132
    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
  •  


Click Here to Expand Forum to Full Width