Dump file size vs. table size

[kennykilla]

Hello!
Can anyone tell me how to determine ASCII dump file size when table size known?
For instance if i have 100Gb table named "test" what size will be the "test.d" file?
I running Prgress 10 on Solaris.

 

[taqvia]

run dbanalys . This will give you a true picture.

 

[kennykilla]

I'm not sure that size in dbanalys will be equal to ASCII dump file size. I think dump will be bigger.

 

[TomBascom]

It depends. DB storage for some data types is potentially much smaller than the ASCII representation. So the actual mix of data in your table is very significant.

The only way to be sure is to run a test dump.

Until I run a test dump for guessing purposes I usually expect 1.5x whatever dbanal says. But I've seen 2x or more.