Re: Help need

[Saurabh Sharma]

Title: Help need

Hi deewakar,   hope this will help..   SELECT TABLESPACE_NAME,TABLE_NAME,INDEX_NAME FROM DBA_INDEXES ORDER BY 1,2,3 /   Saurabh Sharma Oracle DBA [EMAIL PROTECTED] http://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 <<Deewaker G.V..vcf>>