<div>
you need to know the size of the data itself.<br />
<br />
Are those 150 blobs, each of which contains &nbsp;blu-ray content? &nbsp;or are they 150 char(1) fields?<br />
<br />
Also need to take into account indexes which may fill the same or a different tablespace as the table.<br />
<br />
Also need to consider if you have compression on the table, indexes, or tablespace and what kind of compression.<br />
Then need to know the actual data to determine just how compressible it is.<br />
<br />
Also need to know the pctfree defined for each.
</div>


you need to know the size of the data itself.

Are those 150 blobs, each of which contains  blu-ray content?  or are they 150 char(1) fields?

Also need to take into account indexes which may fill the same or a different tablespace as the table.

Also need to consider if you have compression on the table, indexes, or tablespace and what kind of compression.
Then need to know the actual data to determine just how compressible it is.

Also need to know the pctfree defined for each.

<div>
95% Columns are varchar2(5 byte)<br />
it is staging table so no indexes are there<br />
no compression o tables<br />
pctfree is 10
</div>


95% Columns are varchar2(5 byte)
it is staging table so no indexes are there
no compression o tables
pctfree is 10

<div>
<div class="content wysiwyg-content">
Hi,<br />
i have two tables to be loaded from flat file and i am trying to figure how much space they might need to get loaded<br />
<br />
First file has 615908 rows &nbsp;other file has 1611660 rows <br />
first file has 150 columns and other file has 25 columns<br />
<br />
Thanks
</div>
</div>


Hi,
i have two tables to be loaded from flat file and i am trying to figure how much space they might need to get loaded

First file has 615908 rows  other file has 1611660 rows 
first file has 150 columns and other file has 25 columns

Thanks

space needed to load tables

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.