My Oracle Support Banner

INDEX BECOMES UNUSABLE STATUS WHEN TARGET TABLE CONTAINS PARTITION (Doc ID 3036795.1)

Last updated on JULY 31, 2024

Applies to:

Oracle Financial Services Data Integration Hub - Version 8.1.2 and later
Information in this document applies to any platform.

Symptoms

Partition Exchange in the connector results in Target Table having Unusable indexes

Steps to Reproduce :

Created Partition as below on target table

ALTER TABLE STG_ACCOUNT_ADDRESS MODIFY PARTITION BY RANGE ("FIC_MIS_DATE") (PARTITION "P20211020" VALUES LESS THAN (TO_DATE('2021-10-21', 'YYYY-MM-DD'))) ONLINE;

Data loads properly and connector execution is successful, After the connector execution status of index is unusable in user_ind_partitions

SELECT PARTITION_NAME,INDEX_NAME,STATUS FROM user_ind_partitions where index_name='PK_1197';

P20211020 PK_1197 UNUSABLE

Changes

 NA

Cause

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
Symptoms
Changes
Cause
Solution
References


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