Re: retrieve index definition

SF,

You can try the following views

   ALL_IND_COLUMNS
   COLUMNs comprising INDEXes on accessible TABLES

   DBA_IND_COLUMNS
   COLUMNs comprising INDEXes on all TABLEs and CLUSTERs

   USER_IND_COLUMNS
   COLUMNs comprising user's INDEXes or on user's TABLES

And for these output you can execute 'select * from dict' in sqlplus to get them above and more.

shdu_at_my-deja.com wrote:
>
> How do I retrieve index definition in sqlplus.
>
> I can not install database ide here.
>
> Thanks.
>
> SF
>
> Sent via Deja.com
> http://www.deja.com/
 

-- 
Leon L. Zhang
Email: lzhang1_at_lucent.com