Re: Describing indexes of a table in OCI

andras wrote:
>
> Hello to you all,
>
> I would like to get a description of all indexes of a specific
> table. I have seen the 'table description' structure for
> OCIDescribeAny() in the docs so I am aware of the node structure
> and I also am able to describe the columns of a table without
> problems.
>
> My specfic question to you is what OCIAttrGets and OCIParamGets
> should I use to access 'statistics' -> 'indexes' -> ... from the
> describeTableHandle.
>
> I have tried to figure it out from the header file but I could
> find no OCI_ATTR_LIST_STATISTICS, OCI_ATTR_LIST_INDEX or anything
> like that.

Why don't you just query the data dictionary?

-> user_indexes, user_ind_columns ...

Uwe

-- 
Uwe Schneider       | Telefon +49 7244 / 609504
Haydnstr. 1         | Mail    uwe_at_richard-schneider.de
DE-76356 Weingarten | http://www.richard-schneider.de/uwe
Linux - OS al dente!