GoldenGate OGG-01154

错误信息:

2011-03-29 15:53:57  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, repya.prm:  SQL error 14402 mapping EPMA.D_METER to E

PMA.D_METER OCI Error ORA-14402: updating partition key column would cause a partition change (status = 14402), SQL <UPDATE “EPMA”.”D_METER” SET “PR_ORG” = :a1,”BELONG_DEPT” = :a2 WHERE “METER_ID” = :b0>.

处理方法:

SQLPLUS>alter table SCHEMA.TABLENAME enable row movement

Comment

*

沪ICP备14014813号-2

沪公网安备 31010802001379号