Exporting to Multiple dump files in Oracle 7
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Exporting to Multiple dump files in Oracle 7

  1. #1
    Join Date
    May 2002
    Posts
    36

    Post Exporting to Multiple dump files in Oracle 7

    Is there a way in Oracle 7 by which we can export into multiple files. My problem here is that i have tables in a schema of 6GB size.Now i want to export them and make sure that the dump file size does not increase the 2 GB limit.

    Any Suggestions

    Thanks

    Sam

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    No. exp to a named pipe that does compress. Search this site for several thousand examples.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    The code given below I used extensively in Oracle 7.
    The credit must go to Deverajan Sundaravardan.

    PHP Code:
    # January 16, 1998 
    # Exporting a Database That's More Than 2GB When Compressed
    # This Tip of the Week entry comes from Devarajan Sundaravaradan, 
    # a Senior Consultant for Leading Edge Systems, Inc. in Edison, New Jersey. 

    # Also, consider mkfifo command in HP, instead of mknod command.
    #
    # In HP-UX, there is a 2GB limit on file sizes of 2GB.
    # Many of us have reached this limit when exporting files and 
    # the most common solution is to do a filesystem compression of the 
    # export dump using named pipes and then store the compressed file. 
    # But what if the compressed file itself passes the 2GB limit? 
    # There is solution to this, too. 


    # --------- Export Section

    # Create new Named pipes.

    mknod -/dev/split_pipe


    # You can use the existing named pipe itself, instead of creating new.

    mknod -/dev/compress_pipe 

    ======================================================
    # Create a shell script under a file, named Split_export.sh
    =======================================================

    # -b1000m indicates to split command to split the input file into 
    # every 1000 MB size. 

    # As it splits, the split command will suffix aa, ab, ac, ad ... upto zz 
    # to the file name specified.

    # The export file name is expfile.

    nohup split -b1000m < /dev/split_pipe > /DumpDir/expfile 

    nohup compress < /dev/compress_pipe > /dev/split_pipe &

    exp username/password full=y file=/dev/compress_pipe and other parameters for export.

    ==========================================================
    # After saving the above three commands in split_export.sh, 
    # execute the following.
    =========================================================

    chmod a+x split_export.sh

    nohup split_export
    .sh > /tmp/split_export.log 1>&&

    =============================================================
    After a few minutes you should see files in the export dump directory.
    ===========================================================
    ------------------ 
    IMPORT Section

    ========================================================
    # Create a shell script with the following command 
    # under the file name split_import.sh.

    # After creating provide execution permission to this script as follows: 
    =========================================================

    Chmod a+x split_import.sh

    # The import script assumes in this example that the 
    # above export script created 2 split files 

    # called expfileaa and expfileab. The order of the file for the 
    # cat command is very important.

    nohup cat /dumpdir/expfileaa /dumpdir/expfileab > /dev/split_pipe 

    # sleep 3 seconds

    Sleep 3

    nohup uncompress 
    < /dev/split_pipe > /dev/compress_pipe &

    # Sleep at this point is very important as some time is needed 
    # to uncompress the file and send it to the pipe.

    sleep 60

    imp username
    /password file=/dev/compress_pipe and other parameters for export.

    nohup split_import.sh > /tmp/split_import.log 1>&&

    =====================================================
    Wait for the import to finish.
    ===================================================== 
    Tamil

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    You can't use...

    FILE=D:\EXPORT\YO_MOMMA_1.DMP
    FILE=D:\EXPORT\YO_MOMMA_2.DMP
    FILE=D:\EXPORT\YO_MOMMA_3.DMP
    FILE=D:\EXPORT\YO_MOMMA_4.DMP
    filesize=1900M

    in version 7?
    I remember when this place was cool.

  5. #5
    Join Date
    Jan 2001
    Posts
    3,131

    Re: Exporting to Multiple dump files in Oracle 7

    Originally posted by samx18
    Is there a way in Oracle 7 by which we can export into multiple files. My problem here is that i have tables in a schema of 6GB size.Now i want to export them and make sure that the dump file size does not increase the 2 GB limit.

    Any Suggestions

    Thanks

    Sam
    Enable large files in your Unix environment.
    I remember when this place was cool.

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by Mr.Hanky
    You can't use...

    FILE=D:\EXPORT\YO_MOMMA_1.DMP
    FILE=D:\EXPORT\YO_MOMMA_2.DMP
    FILE=D:\EXPORT\YO_MOMMA_3.DMP
    FILE=D:\EXPORT\YO_MOMMA_4.DMP
    filesize=1900M

    in version 7?
    Ah, grasshopper, you're showing your lack of experience.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #7
    Join Date
    Jan 2001
    Posts
    3,131
    I came on board in version 8, that is why I asked.
    I remember when this place was cool.

  8. #8
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    exp user/pwd files=(d:\1.dmp,d:\2.dmp..) filesize= 2G

  9. #9
    Join Date
    Jan 2001
    Posts
    3,131
    Originally posted by Halo
    exp user/pwd files=(d:\1.dmp,d:\2.dmp..) filesize= 2G
    And you are a "Moderator"?
    Read the post sparky.
    I remember when this place was cool.

  10. #10
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    BTW, who the heck uses Oracle 7 these days. Are we going back to stone age? For crying out loud 8i has been desupported.

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