Compressed Export file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Compressed Export file

  1. #1
    Join Date
    Apr 2002
    Posts
    291

    Compressed Export file

    Dear sir,
    I'm running with Oracle 8.1.6 on RH Linux 6.2EE. My daily export dump files are very huge and my disk space fallen alarmingly low. I want to do a compressed export using gzip and split, as Linux 6.2 has a limitation in size of 2G per file. If Any one out here had already implemented the same, can you please post the script, here . Actually I wrote a small script but it is throwing errors:
    ERROR:
    split: /u09/mytools/expimp/expdmp.gz_: No such file or directory
    LRM-00118: syntax error at '=' at the end of input
    EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
    EXP-00000: Export terminated unsuccessfully

    Here is my Script:
    ====================
    # -- export_dl.sh:
    ORACLE_HOME=/opt/oracle/product/8.1.6
    ORACLE_SID=cmsrpt1
    OUTPUT_FILE=/u09/mytools/expimp/expdmp.gz_
    export ORACLE_HOME ORACLE_SID OUTPUT_FILE
    #
    # Creation of a pipe for output of export
    rm -f /u09/mytools/expimp/p
    mkfifo -m 777 /u09/mytools/expimp/p
    # Start export
    #
    cat p|gzip |split -b 1000m ${OUTPUT_FILE} &

    #created an external user OPS$ORACLE inorder to protect
    #user ids and passwords.

    /opt/oracle/product/8.1.6/bin/exp / FILE=$p \
    PARFILE=/u09/mytools/expimp/testexportparam_dl

    # End export
    exit

    --testexportparam_dl:

    # -- exportparam_dl :
    LOG=/u09/mytools/logs/testexport_dl.log
    CONSISTENT=Y
    COMPRESS=N
    #OWNER=dloader
    TABLES=(d_claim,d_fintx)

    It would be a great help for me if any one can correct this script or send me their script which is implemented successfully. Because i need to productionalise this script by today evening.

    Many Thanks in advance
    PNRDBA

  2. #2
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Export through a named pipe.

    http://www.experts-exchange.com/CXO/..._20569914.html

    Just keep in mind you'll need to import via the pipe as well.
    Last edited by KenEwald; 06-17-2003 at 03:45 PM.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  3. #3
    Join Date
    Apr 2002
    Posts
    291
    Thanks for your kind help Ken. I'll go thru that site and try to implement it.
    PNRDBA

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