ORA-14402: updating partition key column would cause a partition change
ODI JOB failure with following error ORA-14402: updating partition key column would cause a partition change on RADM.W_RTL_BCOST_IT_LC_DY_F
Any ideas?
the partition is: PARTITION BY RANGE (FROM_DT_WID) SUBPARTITION BY HASH (ORG_DH_WID) SUBPARTITION TEMPLATE. The column ORG_DH_WID is also part of the update an might be changing. From the DB perspective is ok to update a column from a partition
The query related is:
update RADM.W_RTL_BCOST_IT_LC_DY_F t
set (
t.PROD_SCD1_WID,
t.ORG_DH_WID,
t.ORG_SCD1_WID,
t.SUPPLIER_WID
Any ideas?
the partition is: PARTITION BY RANGE (FROM_DT_WID) SUBPARTITION BY HASH (ORG_DH_WID) SUBPARTITION TEMPLATE. The column ORG_DH_WID is also part of the update an might be changing. From the DB perspective is ok to update a column from a partition
The query related is:
update RADM.W_RTL_BCOST_IT_LC_DY_F t
set (
t.PROD_SCD1_WID,
t.ORG_DH_WID,
t.ORG_SCD1_WID,
t.SUPPLIER_WID
0