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