Oracle Database 12.1.0.2
Solaris 11.4
GG 18
Hi,
I have a table on target which is partitioned monthly. Partitions are already precreated but in a different tablespace compared to source where all partitions are in 1 tablespace.
Is there a way I can bypass the ADD PARTITION statement for error message below for table GPRS_HOME_CDRS?
2019-12-01T10:47:57.689+0400 INFO OGG-00484 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Executing DDL operation.
2019-12-01T10:47:57.801+0400 ERROR OGG-00519 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Fatal error executing DDL replication: error [Error code [14760], ORA-14760: ADD PARTITION is not permitted on Interval partitioned objects SQL Alter table "CBSOGG"."GPRS_HOME_CDRS" add partition POST_CDR_202001010000 values less than
(to_date(' 2020-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS','NLS_CALENDAR=GREGORIAN')) tablespace cbs /* GOLDENGATE_DDL_REPLICATION */], no error handler present.
2019-12-01T10:48:03.891+0400 INFO OGG-02333 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Reading /ogg/ora12c/dirdat/cd000001227, current RBA 110,895,318, 8,393,149 records, m_file_seqno = 1,227, m_file_rba = 110,896,826.
2019-12-01T10:48:03.964+0400 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, reploggt.prm: PROCESS ABENDING.
2019-12-01T10:52:57.488+0400 INFO OGG-01487 Oracle GoldenGate Capture for Oracle, extdwh.prm: DDL found, operation [Alter table GPRS_HOME_CDRS add partition POST_CDR_202002010000 values less than
(to_date(' 2020-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS','NLS_CALENDAR=GREGORIAN')) tablespace cbs (size 181)], start SCN [272546076872], commit SCN [272546076899] instance [ (2)], DDL seqno [0], marker seqno [0].
2019-12-01T10:52:57.489+0400 INFO OGG-00487 Oracle GoldenGate Capture for Oracle, extdwh.prm: DDL operation included [INCLUDE MAPPED], optype [ALTER], objtype [TABLE], objowner CBS_CUST, objname GPRS_HOME_CDRS.
2019-12-01T10:52:57.492+0400 INFO OGG-01487 Oracle GoldenGate Capture for Oracle, extdwh.prm: DDL found, operation [Alter table GPRS_HOME_CDRS add partition POST_CDR_202003010000 values less than
(to_date(' 2020-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS','NLS_CALENDAR=GREGORIAN')) tablespace cbs (size 181)], start SCN [272546077029], commit SC
Regards,
Joe