Wrong Results for Partitioned Table after TTS Import when Export done with UNUSABLE Bitmap Index Partition
(Doc ID 2158312.1)
Last updated on FEBRUARY 20, 2019
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
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.
Partitioned table with bitmap index was moved via TTS from the source to target database.
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