06 March 2011

Export large database without using much diskspace

I have one pretty large database running in one of our development environments. I was wondering if this Oracle 8i database could be easily exported. I didn't have much space for export files, so I used compression during export with a script a found  at http://www.tc.umn.edu/~hause011/code/exp-imp-db.ksh.




How much compression would it give me and how long would it take?


Here are some results:


Database 8.1.7.4 on AIX 5.
Export running 40 hours
database size: 236 Gb
export dumpfile (gzip) 16Gb


Import would take considerably longer, because indexes would need te be created. I would guess around a week. The export time will probably not have been much shorter without compression.

No comments:

Post a Comment