Wrong Results for Partitioned Table after TTS Import when Export done with UNUSABLE Bitmap Index Partition (Doc ID 2158312.1)

Last updated on JULY 06, 2016

Applies to:

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

Symptoms

If you execute a transportable tablespaces (TTS) export on a partitioned table when that table has a bitmap index partition marked UNUSABLE in the source database, you may get wrong results after the table is imported, and the index partition may now show as USABLE in the target.   This does not seem to happen when a regular index is marked UNUSABLE prior to export, only with a bitmap index.

Example: 

 

Changes

 Partitioned table with bitmap index was moved via TTS from the source to target database.

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