Where is long and long raw data stored?

[Former Member]

Is the data for long and long raw columns stored within the tables main segment? I believe it is, via chained rows/blocks, however I want to be sure that I am calculating the size of these tables correctly. Do I only look in dba_segments? If not, how is this data stored and what do I need to due to calculate the size of the tables?

If the columns were LOB columns, then the data would be stored in separate segments. However, long and long raw columns are not stored the same as LOB columns.

[fidel_vales · Accepted solution]

Hi,

you are correct, the "long raw" data is stored inline. No different object is used.

The size of the table can be found using dba_extents (or db02)