Re: How can I get a list of all indexes in SQL Plus?

From: Steve Bell <swayne.bell_at_sympatico.ca>
Date: Fri, 02 Mar 2001 12:52:12 GMT
Message-ID: <3A9F9592.5050901@sympatico.ca>

Hi James,
You can query DBA_INDEXES..(or USER_INDEXES if you don't have DBA access...log in as the user who created the index) SQL> desc DBA_INDEXES

Then choose the column(s) you need...INDEX_NAME is one of the columns.

You can also specify the OWNER in the WHERE clause to narrow the search. Hope this helps,
Steve

James Alexander Starritt wrote:

> I have a user who appears to have dropped a key index on her database. Now
> instead of shooting in the dark trying to find it I was wondering if there
> was a select or desc statement I can use to list all indexes ??
>
> --
>
> James Alexander Starritt (james_at_jamesstarritt.com)
>
> I am testing and developing a new search engine for Pro-Wrestling related
> sites. If you would like to get a few hits send an email along with your
> URL and Site Name to search_at_menintights.net and I will add you to the
> search.
>
>
>
Received on Fri Mar 02 2001 - 06:52:12 CST