ORA-02448 Constraint Does Not Exist Error While Doing Table Reorg.

(Doc ID 2331381.1)

Last updated on NOVEMBER 22, 2017

Applies to:

Oracle Demantra Predictive Trade Planning - Version 12.2.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.2 version, Technical



We are getting the below error while doing the reorg. We have set the PLSQL IDENTIFIERS to NONE and again started the table org process but getting the same error.

Tried for different tables like sales_data,mdp_matrix and settlement but it giving same error for all tables.



ERROR
-----------------------
ORA-02448Error report:
ORA-02448: constraint does not exist
ORA-06512: at "SYS.DBMS_REDEFINITION", line 105
ORA-06512: at "SYS.DBMS_REDEFINITION", line 3520
ORA-06512: at line 2
02448. 00000 - "constraint does not exist"
*Cause: The named constraint does not exist
*Action: Stop trying to do something with a nonexistant constraint

However they are able to successfully do the reorg after using the below commands.

alter session set "_px_filter_parallelized"=false;
alter session set "_fix_control" = "10043801:OFF";

Why do they need to use these commands to run successful reorg?



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Run the table re org tool

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot do a table re org impacting the performance

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