From ssharma1@fcsltd.com Fri, 27 Jul 2001 02:04:36 -0700 From: "Saurabh Sharma" Date: Fri, 27 Jul 2001 02:04:36 -0700 Subject: Re: Help need Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: Help need Hi deewakar,   hope this will help..   SELECT TABLESPACE_NAME,TABLE_NAME,INDEX_NAME FROM DBA_INDEXESORDER BY 1,2,3/   Saurabh Sharma Oracle DBA saurabh00pc@yahoo.comhttp://www.geocities.com/saurabh00pc/stride.html
----- Original Message -----
From: Deewaker G.V. To: Multiple recipients of list ORACLE-L Sent: Friday, July 27, 2001 2:20 PM Subject: 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 <>