Flat file to table - thumb rule for size estimation
561510Feb 13 2007 — edited Feb 15 2007Hello,
I need to do a quick-and-dirty estimate of flat file to table size increase in size. Some kind of thumb rule.
I.e suppose I have 100MB of flat file data and put this data into a table, what is the typical increase in size in the Oracle database.
I know there would be factors such as number of columns, type of columns, etc that would impact the size occupied in the database. (Ignore indexes).
But from experience is there a thumb rule for this? I need to do some estimation for disk requirements.
Thank you.