My Oracle Support Banner

Wrong Results From Index Organized Table (IOT) Using Secondary Index (Doc ID 2589388.1)

Last updated on NOVEMBER 21, 2019

Applies to:

Oracle Database - Standard Edition - Version and later
Information in this document applies to any platform.


Wrong results from Index Organized Tables (IOT) under following scenario:
1. Index-Organized Table (IOT) with multi-column primary key populated with rows.
2. The table has a secondary index on the sub leading column of multi-column primary key.
3. Another column is added to the existing IOT.
4. Wrong result report for the newly added column when the secondary index is accessed.


When secondary index is created to the IOT.

There is a similar <Bug 14472647> reported but fixed in

<Document 14472647.8> Bug 14472647 - Wrong results on IOT secondary index after DML.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.