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: 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