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 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