Re: List table's indexes !

select table_name, index_name
from user_indexes
order by table_name, index_name;

select table_name, index_name, column_name from user_ind_columns
order by table_name, index_name, column_position;

for further details

Anyone should not be without
Oracle, the complete reference
and
the Oracle DBA Handbook
both from Osborne/Oracle Press

Hth,

--
Sybrand Bakker, Oracle DBA
Pascal-Eric Servais <servpas_at_cognicase.ca> wrote in message news:862k13$p09$1_at_nnrp1.deja.com...
> Hi !
> I am a little green with Oracle DB and working on a "rush" project !
> (same as usual ;)
>
> I just can't figure out how to list all the indexes that are
> associated to an Oracle table with SQL*Plus.
> Is anybody could help about that.
>
> BTW : If you are aware of any link to good online manuals, like some
> "Getting started with Oracle", I'd appreciate very much.
>
> Thanks !
>
> Pascal-Eric.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Jan 18 2000 - 15:39:14 CST