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

  • From: BN <bnsarma@xxxxxxxxx>
  • To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 27 Jan 2006 14:03:49 -0500

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2006