Hi,
What i having troubling is that successful DDL is happening on new tables but whenever i m trying to do any new DML on those tables is doesn't replicate ?
Below the details
@Source
GGSCI (prod.naveed.com) 1> view params ext1
EXTRACT ext1
USERID ggs_owner, PASSWORD ggs_owner
EXTTRAIL /home/oracle/golden_gate/dirdat/lt
DDL INCLUDE ALL
ddloptions getreplicates, getapplops,addtrandata, report
TABLE NAVEED.ORDER_T;
TABLE NAVEED.PRODUCT_T;
TABLE NAVEED.ORDER_LINE_T;
GGSCI (prod.naveed.com) 2> view params dpump
EXTRACT dpump
USERID ggs_owner, PASSWORD ggs_owner
RMTHOST Test.naveed.com, MGRPORT 7809
RMTTRAIL /home/oracle/golden_gate/dirdat/rt
PASSTHRU
TABLE NAVEED.ORDER_T;
TABLE NAVEED.PRODUCT_T;
TABLE NAVEED.ORDER_LINE_T;
@Target
GGSCI (Test.naveed.com) 11> view params rep1
REPLICAT rep1
-- This starts the macro
MACRO #exception_handler
BEGIN
, TARGET ggs_owner.exceptions
, COLMAP ( rep_name = "REP1"
, table_name = @GETENV ("GGHEADER", "TABLENAME")
, errno = @GETENV ("LASTERR", "DBERRNUM")
, dberrmsg = @GETENV ("LASTERR", "DBERRMSG")
, optype = @GETENV ("LASTERR", "OPTYPE")
, errtype = @GETENV ("LASTERR", "ERRTYPE")
, logrba = @GETENV ("GGHEADER", "LOGRBA")
, logposition = @GETENV ("GGHEADER", "LOGPOSITION")
, committimestamp = @GETENV ("GGHEADER", "COMMITTIMESTAMP"))
, INSERTALLRECORDS
, EXCEPTIONSONLY;
END;
-- This ends the macro
ASSUMETARGETDEFS
USERID ggs_owner, PASSWORD ggs_owner
DISCARDFILE /home/oracle/golden_gate/dirrpt/rolap01.dsc, PURGE
REPERROR (DEFAULT, EXCEPTION)
REPERROR (DEFAULT2, ABEND)
REPERROR (-1, EXCEPTION)
MAP NAVEED.ORDER_T, TARGET NAVEED.ORDER_T;
MAP NAVEED.ORDER_T #exception_handler();
MAP NAVEED.PRODUCT_T, TARGET NAVEED.PRODUCT_T;
MAP NAVEED.PRODUCT_T #exception_handler();
MAP NAVEED.ORDER_LINE_T, TARGET NAVEED.ORDER_LINE_T;
MAP NAVEED.ORDER_LINE_T #exception_handler();
GGSCI (Test.naveed.com) 12> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP1 00:00:00 00:00:05
GGSCI (Test.naveed.com) 13>