Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: What Indexes do I have???

Re: What Indexes do I have???

From: Joseph S. Testa <teci_at_oracle-dba.com>
Date: 1998/02/24
Message-ID: <34F2B4C5.28D09C4A@oracle-dba.com>#1/1

how about looking at user_indexes and the table_name attribute to see what indexes exist on that table.

--
Joseph S. Testa, Oracle Database Administrator,
mailto:dba_at_oracle-dba.com (home)
Vice-President Ohio Oracle Users Group, http://www.ooug.org
See the Oracle FAQ at http://www.orafaq.org
Try http://www.oracle-dba.com that is also the place to find the FREE,
drop column script
ICQ UIN:  2832230(&oracle, home).
Received on Tue Feb 24 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US