Exec_row_movement_interval_1 ORA-14402: Updating Partition Key Column Would Cause A Partition Change
(Doc ID 2162418.1)
Last updated on AUGUST 08, 2023
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
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
Goal |
Solution |
References |