RE: Looking for a Script to list tables,its indexes and sizing info

From: Joseph Amalraj <joseph_at_amalrajinc.com>
Date: Fri, 27 Jan 2006 11:41:41 -0800 (PST)
Message-ID: <20060127194141.17849.qmail@web312.biz.mail.mud.yahoo.com>

dba_segments would be faster.

Igor Neyman <ineyman_at_perceptron.com> wrote: Look at dba_extents.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of BN Sent: Friday, January 27, 2006 2:04 PM
To: Oracle-L Freelists
Subject: Looking for a Script to list tables,its indexes and sizing info

Greetings,

Oracle 9iRel2:

I am looking for a script to report the following info for the (given) table and its indexes

  OWNER    TYPE     TABLESPACE         SEGMENT_NAME                   IEXT_KB    EXTENTS         MB


-------- -------- ------------------ --------------------------- ---------- ---------- ---------- 

ABC      Table     TBS1               Table1                        NNNN      NNN        NNNNNNN
           Index     TBS2               Index1                        nnnn       nn        nnnnnnn
                     TBS2               Index2                        nnnn       nnnn     nnnnnnnn
                                        ......
   
           Table     TBS3               Table2                        nnnn      nnnn      nnnnnnn
           Index     TBS4               Index1                        nnnn      nnnn      nnnnnnnn

..........

Thank you inadvance

Regards & Thanks
BN

--

http://www.freelists.org/webpage/oracle-l Received on Fri Jan 27 2006 - 13:41:41 CST