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.
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.
compress=y does not compress the export, read the manuals before giving bad advice
Originally Posted by raghav.s.dba
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
no option at database level?
An export generated dump file is a file at the Operating System level - that's why.
Originally Posted by iris
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.
Click Here to Expand Forum to Full Width