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

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to show all indexes?

Re: How to show all indexes?

From: Michel Cadot <micadot_at_netcourrier.com>
Date: 2000/05/29
Message-ID: <8gu9o6$15ts$1@s2.feed.news.oleane.net>#1/1

With the dba_indexes or user_indexes view:

select table_name, index_name from dba_indexes where owner='<your user>'
order by 1, 2
/

--
Have a nice day
Michel


kev <kevin.porter_at_fast.no> a écrit dans le message : 3932C31A.64D1BCEE_at_fast.no...

> Hi,
>
> How do I get a list of what indexes have been created for a particular
> user?
>
> thanks,
>
> - Kev
>
Received on Mon May 29 2000 - 00:00:00 CDT

Original text of this message

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