Help need

[Deewaker G.V.]

Title: Help need

HI DBA Guru's

I wanted to know all the Index names under respective table spaces

For example

Tablespace is Production
        Table name : customer, item, supplier
            index Names  idx_customer_custid
                          idx_customer_name
                          idx_item_itemid
                          idx_item_name
                          idx_supplier_itemid
                          idx_supplier_name
       
Tablespace is Quality
        Table name : customer, item, supplier
            index Names  idx_customer_custid
                          idx_customer_name
                          idx_item_itemid
                          idx_item_name
                          idx_supplier_itemid
                          idx_supplier_name

Tablespace is Development
        Table name : customer, item, supplier
            index Names  idx_customer_custid
                          idx_customer_name
                          idx_item_itemid
                          idx_item_name
                          idx_supplier_itemid
                          idx_supplier_name

with warm regards,

Deewaker G. V.

Baazee.com India Pvt. Ltd.
(: 4611323 Extn: 216
Fax : 4611324

<<Deewaker G.V..vcf>>

Deewaker G.V..vcf