DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SYS_NC00005$ in DBSCHEMA_INDEXES.COLUMN_NAME

imagic1Apr 13 2010

Hi,

I would like to get properties of indexes via OLEDB schema of indexes.
There is a table that have an index with two column, Col2 DESC, Col3 ASC.
I receive fals column name from schema rowset: SYS_NC00005$ for Col2 (I guess it is for DESC) and content COLLATION field also wrong (DB_COLLATION_ASC).
How can I get right data (properties)?
Thank you for any idea.

Regards,
Imre

Locked Post

New comments cannot be posted to this locked post.

Locked on May 11 2010

Added on Apr 13 2010

#oracle-provider-for-ole-db, #windows-and-net

0 comments

1,511 views