Database DataWarehousing (MOSC)

MOSC Banner

ODI job failure

edited Sep 23, 2013 4:48AM in Database DataWarehousing (MOSC) 3 commentsAnswered
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