Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how do I find out column name on which a index is build
The following script should do it
select rpad(table_name,20) table_name, rpad(index_name,30) index_name,
rpad(column_name,10) column_name
from user_ind_columns (or DBA_IND_COLUMNS or ALL_IND_COLUMNS)
order by table_name
In article <93g7vf$h9c$1_at_nnrp1.deja.com>,
David Fitzjarrell <oratune_at_aol.com> wrote:
> 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/
>
Sent via Deja.com
http://www.deja.com/
Received on Wed Jan 10 2001 - 15:50:59 CST