size of a table

[cravi]

hey guys

u can use this query to find out the size of a table:



select owner||'.'||segment_name Segment_Name
, segment_type "Segment Type"
, sum(bytes)/1024/1024 "Size In MB"
from dba_segments
group by owner||'.'||segment_name
, segment_type;

Ravi