Help need

From: Deewaker G.V. <Deewaker_at_baazee.com>
Date: Fri, 27 Jul 2001 00:52:28 -0700
Message-ID: <F001.00356D3F.20010727005022@fatcity.com>

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

Received on Fri Jul 27 2001 - 02:52:28 CDT