DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: dump file size

  1. #1
    Join Date
    Mar 2008
    Posts
    140

    dump file size

    Hi, my one schema dump size is 28 GB taken with utility exp.


    My question is:

    How to compress this size, as i don't have enough space on my disk to save this dump file.



    thanks,

  2. #2
    Join Date
    Dec 2010
    Location
    Bangalore, India
    Posts
    8
    If the export dmp is already taken, use zip or compress option using OS commands. The other option would be to use parameter compress=y while taking an export.

    Thanks
    Raghav

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Quote Originally Posted by raghav.s.dba View Post
    If the export dmp is already taken, use zip or compress option using OS commands. The other option would be to use parameter compress=y while taking an export.

    Thanks
    Raghav
    compress=y does not compress the export, read the manuals before giving bad advice

  4. #4
    Join Date
    Dec 2010
    Location
    Bangalore, India
    Posts
    8
    Sorry for that bad advice. My apology. If you are on Unix environment you can use mknod pipe option.

    Like the below example.
    mknod exp.pipe x
    gzip < exp.pipe > test.exp.gz &
    exp userid=test/pwd file=exp.pipe

  5. #5
    Join Date
    Mar 2008
    Posts
    140
    no option at database level?

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by iris View Post
    no option at database level?
    An export generated dump file is a file at the Operating System level - that's why.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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