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

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Fri, 27 Jan 2006 14:30:43 -0500
Message-ID: <F4C27E77F7A33E4CA98C19A9DC6722A2A8CA28@EXCHANGE.corp.perceptron.com>

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:30:43 CST