Based on what I think you are trying to acheive, I would recommend you
take a look at user_segments or dba_segments. If you do a describe
dba_segments (provided you have the right privileges) then you will see
columns like table_name, owner, bytes, extents and so on.
Note that on some tables where not a whole lot of data is inserted, you
may not see any difference in size between the before and after the
data load, even if the number of rows is increased. This is because
Oracle reports the amount of space allocated to a segment (table or
index) but part of it could be free to store more records. As this
space runs out, another extent of storage will be allocated to the
segment. This allocated space is 'consumed' in the sense that it is not
available for anything else, meaning you can pre allocate all the free
space in a database, with virtually no data. If what you are asking is
"is there enough free space for a table to grow by another 1K", then
the answer might be no, but if what you are asking is "can I load
another 1M of data" the answer might be yes (as there might be enough
pre allocated space to handle another 1000 rows without needing to
allocate more space).
HTH
Received on Thu Nov 03 2005 - 12:12:12 CST
