Exec_row_movement_interval_1 ORA-14402: Updating Partition Key Column Would Cause A Partition Change (Doc ID 2162418.1)

Last updated on MARCH 27, 2017

Applies to:

Oracle SOA Suite - Version 12.1.3.0.0 to 12.1.3.0.0 [Release 12c]
Information in this document applies to any platform.

Goal


verify script for dropping partition reports the following

CHECKING SCA_FLOW_INSTANCE PARTITION SYS_P433
----------------------------------------------------
** FAIL TOTAL FLOWS : 189984
** FAIL FLOWS STILL OPEN : 1074 (.57%)
CHECKING CUBE_INSTANCE PARTITION SYS_P442
----------------------------------------------------

Running verify_soa.exec_row_movement_interval_1('SYS_P433', TO_TIMESTAMP('2016-06-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'));

Gets the following error

ERROR at line 1:
ORA-14402: updating partition key column would cause a partition change
ORA-06512: at "FMWSD_SOAINFRA.VERIFY_FABRIC", line 126
ORA-06512: at "FMWSD_SOAINFRA.VERIFY_FABRIC", line 656
ORA-06512: at "FMWSD_SOAINFRA.VERIFY_SOA", line 84
ORA-06512: at line 1
 

Solution

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