Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: List table's indexes !

Re: List table's indexes !

From: GHouck <hksys_at_teleport.com>
Date: Tue, 18 Jan 2000 15:33:25 -0800
Message-ID: <3884F845.ECF@teleport.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US