Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How to show all indexes?
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...Received on Mon May 29 2000 - 00:00:00 CDT
> Hi,
>
> How do I get a list of what indexes have been created for a particular
> user?
>
> thanks,
>
> - Kev
>