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

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

Re: How to show all indexes?

From: stevieG <stevie-g_at_gmx.de>
Date: 2000/05/29
Message-ID: <8gu9t8$jr9$10$1@news.t-online.com>#1/1

kev <kevin.porter_at_fast.no> schrieb in im Newsbeitrag: 3932C31A.64D1BCEE_at_fast.no...
> How do I get a list of what indexes have been created for a particular
> user?

select *
  from dba_indexes
  where table_owner = 'THE_USER'; Received on Mon May 29 2000 - 00:00:00 CDT

Original text of this message

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