On Thu, 2003-07-03 at 10:02, Nurullah Akkaya wrote: > i use show status command to calculate the size of a table but i cant seem > to find an option to calculate the table size in oracle i tried > select sum(bytes)/1024/1024 from 'table_name'; but this did not workr i can > calculate the size of the whole database with select sum(bytes)/1024/1024 from > dba_extents; do you know a solution.
This will give bytes allocated to a table which will be >= the bytes used to store the actual data. By the way, in addition to the dba_segments table (view), there is also a user_segments that has no owner column. Good for 8i and 9i. select owner, segment_name, sum(bytes) from dba_segments where owner = '<owner>' and segment_name = '<table_name>' and segment_type = 'TABLE' group by owner, segment_name; -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
