GoldenGate DDL replication fails due to EXCHANGE PARTITION in Source?

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Fri, 9 Feb 2018 18:32:16 -0600
Message-ID: <CAP79kiRSzhspYLVo1xkRJx==As25JGV5Tz-gn2_zEmxxZk+ApQ_at_mail.gmail.com>



GGATE v. 12.1.2.1.170117

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?

Chris

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Feb 10 2018 - 01:32:16 CET

Original text of this message