Retail Merchandising System (MOSC)

MOSC Banner

ORA-14402: updating partition key column would cause a partition change

edited Sep 24, 2013 5:54PM in Retail Merchandising System (MOSC) 1 commentAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center