Re: How can I get index's definition for a table?

hello phil,

i think what you should be doing is:
select * from USER_INDEXES
select * from USER_IND_COLUMNS

both of these view return you the details of indexes and the fields being used in the index. you could easily join both of these views on INDEX_NAME to get the info about indexes you're looking for.

hope that helps at bit.

regards,

:) ATTA PS: for ALL the indexes in your database you could also check out DBA_INDEXES and DBA_IND_COLUMNS views.

In article <pI885.27027$NP5.785700_at_newsread2.prod.itd.earthlink.net>,   "PHIL" <PHIL_SHEU_at_AMAX.COM> wrote:
> Hi,
>
> How can I get index definition for a table.
> for example, I need information that my program generate following
> statement,
>
> CREATE UNIQUE INDEX sysadm.ps_a8_shortage
> ON sysadm.ps_a8_shortage
> (
> business_unit,
> demand_source,
> ...
> demand_line_no)
>
> TABLESPACE psindex
>
> Thanks
>
> Phil
>
>

--

getting the meanin' of data...


Sent via Deja.com http://www.deja.com/
Before you buy.