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