Re: how do I find out column name on which a index is build

In our last gripping episode shdu_at_my-deja.com wrote:
> how do I find out column name on which a index is build
> Thanks
>
> SF
>
> Sent via Deja.com
> http://www.deja.com/
>

Utilise one of the following views:

USER_IND_COLUMNS     Indexed columns on tables the user owns
ALL_IND_COLUMNS      Indexed columns on tables the user has access to
DBA_IND_COLUMNS      Indexed columns on all tables in the database
                     (requires DBA privileges)

One can query the index name, table name, column name, column position and column length for any index (depending, of course, upon which view one chooses).

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/