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: Newbie: table indexes

Re: Newbie: table indexes

From: Marc Mazerolle <informaze_at_sympatico.ca>
Date: Tue, 06 Jul 1999 19:17:33 GMT
Message-ID: <378257DE.A5E9E878@sympatico.ca>


Try the all_ind_columns for columns of the indexes and all_tab_columns for columns of the tables.

Noah Arliss wrote:

> Is there anyway to get the complete index information, including the keys
> that the index was created on out of the oracle database?
>
> the all_indexes table for gives me table name, owner, and index info, but
> not the keys the index exists on.. I need that info..
>
> Noah
Received on Tue Jul 06 1999 - 14:17:33 CDT

Original text of this message

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