BAD DATA IN 10.2.0.2 AFTER IMPORTING TRANSPORTABLE TBS FROM 9.2.0.X (Doc ID 391492.1)

Last updated on JANUARY 21, 2009

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.1.0.4
This problem can occur on any platform.

Symptoms

Bad data results when querying an IOT table using its secondary index AND the table is on a tablespace that was  imported from 9.2.0.x through a transportable tablespace. 

The table has NO unused columns, NO long raw, NO user datatype. 
 
No issues when querying the IOT table WITHOUT using an index. 
No issues when querying the IOT table using its primary key index.

Changes

The table was imported from 9.2.0.x to 10.2.x through a transportable tablespace.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms