Comparing Database Table Size, records and Export Files

The is a listing a an Example Database Table, the size it consumes within the Database and the Size an Export of the same will consume. The “Part” Table contains information of certain Parts which are supplied by different manufactures and looks like the following:

image 

The Table contains 1.4 Mio records:

image

Within the Database this Table consumes “only” 25 MB of storage:

image

When exporting the Table using the Export Wizard of SQL Developer and choosing the loader format,

image

the same Table consumes 147 MB of storage:

image

Thus, the is nearly a factor of 6 between the space a Table consumes within the Database and the exported information of the same.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.