Deewaker,
information you find with this select-stmt, perhaps you need to format the
output.
Depending on what you're looking for you should select either from the view:
user_indexes
all_indexes
dba_indexes
select
table_name,
index_name,
tablespace_name
from user_indexes
group by table_name, index_name, tablespace_name;
TGIF
Stephan
-----Original Message-----
Sent: Friday, July 27, 2001 10:50 AM
To: Multiple recipients of list ORACLE-L
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.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?Q?J=E4ck_Stephan?=
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
