Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: List table's indexes !
Pascal-Eric Servais wrote:
>
> 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.
You can try:
select * from user_indexes where table_name='...'
Yours,
Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys
Received on Tue Jan 18 2000 - 17:33:25 CST
![]() |
![]() |