Table size

Hi,

How shall we find out the size of the tables?
We know to find out the size of the tablespace, could any one tell me thesyntax?


Thanks in advance,


bye
gandhi

Maybe the DBA_SEGMENTS view will help. There is a column name BYTES.

if i am able to undersatnd your question right and what you wanted is the amount of space that is alocated to a table then just use the following query.

SELECT SEGMENT_NAME,SUM(BYTES)
FROM DBA_SEGMENTS
WHERE SEGMENT_TYPE='TABLE'
GROUP BY SEGMENT_NAME

hth