GoldenGate DDL replication fails due to EXCHANGE PARTITION in Source?

From: Chris Taylor <>
Date: Fri, 9 Feb 2018 18:32:16 -0600
Message-ID: <>


We have a new table we added to extract and replicat, however the replicant fails with the following error:

2018-02-09 19:22:17 ERROR OGG-00519 Fatal error executing DDL replication: error [Error code [942], ORA-00942: table or view does not exist SQL ALTER TABLE "SENTINEL"."DISPENSATION_PHYSICIAN" EXCHANGE PARTITION DISPENSATION_PHYSICIAN_496 WITH TABLE DISP_PHYS_496 INCLUDING INDEXES WITHOUT VALIDATION UPDATE GLOBAL INDEXES /* GOLDENGATE_DDL_REPLICATION */], no error handler present.

DISPENSATION_PHYSICIAN is on the extract and replicat but the partition exchange table is not replicated (nor would I know how to go about replicating new tables that are setup for partition exchanges).

SO, I need some guidance/suggestions for a newbie who has inherited an existing GGate environment.

'Lil help?


Received on Sat Feb 10 2018 - 01:32:16 CET

Original text of this message