Wrong Results for Partitioned Table after TTS Import when Export done with UNUSABLE Bitmap Index Partition
Last updated on JULY 06, 2016
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms