Export - using Parfile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Export - using Parfile

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



  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    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


  3. #3
    Join Date
    Oct 2001
    Location
    Hornchurch, Essex UK
    Posts
    132
    Does anyone know how to do this in NT?

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828

    Lightbulb

    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
  •  



Click Here to Expand Forum to Full Width