How TO KNOW TABLE SIZE

2002-03-04 Thread Seema Singh
Hi How can I know how much space a table occupied? Can BLOCKS columns in dba_tables helps? Or I have to use dba_extents and dba_segments tables? Thx -Seema _ MSN Photos is the easiest way to share and print your photos:

Re: How TO KNOW TABLE SIZE

2002-03-04 Thread Bill Gentry
This is what I use. Hope it helps. spool table_space_usage.log set pagesize 0 set linesize 80 select substr (segment_name,1,20) ,bytes / 1024 kbytes ,extents

Re: How TO KNOW TABLE SIZE

2002-03-04 Thread Gene Gurevich
I usually do select sum(bytes) from dba_Segments where segment_name = 'TABLENAME'; HTH --- Seema Singh [EMAIL PROTECTED] wrote: Hi How can I know how much space a table occupied? Can BLOCKS columns in dba_tables helps? Or I have to use dba_extents and dba_segments tables? Thx -Seema

RE: How TO KNOW TABLE SIZE

2002-03-04 Thread Tomita Koga, Alex - (Per)
Asunto: How TO KNOW TABLE SIZE Hi How can I know how much space a table occupied? Can BLOCKS columns in dba_tables helps? Or I have to use dba_extents and dba_segments tables? Thx -Seema _ MSN Photos is the easiest way to share