Hello Expert,
I have configured additional replicate for some more tables. below is the parameter. It was working fine before but getting abended and prompting error to some new table that is not in the parameter.
Parameter
[ggate@ccldclmdb1 dirprm]$ cat bpm.prm
REPLICAT BPM
ASSUMETARGETDEFS
USERID ggadmin@CCLENBD1, PASSWORD ***** SYSDBA
DISCARDFILE /oraggate/ggate/software/enb/dirrpt/bpm_discard.txt, append, megabytes 20
IGNOREDELETES
--REPERROR 1403, discard
--MAP comappo.TABLE_BPM_PROC_INST,TARGET com1appo.TABLE_BPM_PROC_INST_ARC;
REPERROR (-1, IGNORE);
MAP comappo.TABLE_BPM_STEP_INST, TARGET com1appo.TABLE_BPM_STEP_INST_ARC;
-- REPERROR (-1, IGNORE);
--MAP comappo.TABLE_BPM_CONTEXT, target com1appo.TABLE_BPM_CONTEXT_ARC;
-- REPERROR (-1, IGNORE);
--MAP comappo.TABLE_BPM_FAULT_INFO_HIST, com1appo.TABLE_BPM_FAULT_INFO_HIST_ARC;
-- REPERROR (-1, IGNORE);
--IGNOREDELETES
DDLOPTIONS MAPSESSIONSCHEMA COMAPPO TARGET COM1APPO
DDLOPTIONS MAPSESSIONSCHEMA COMAPPC TARGET COM1APPC
DDLOPTIONS MAPSESSIONSCHEMA COMREFWAIT TARGET COM1REFWAIT
DDLOPTIONS MAPSESSIONSCHEMA COMREFWORK TARGET COM1REFWORK
DDLOPTIONS MAPSESSIONSCHEMA GGTEST TARGET GGTESTR
[ggate@ccldclmdb1 dirprm]$
Error:
2012-10-04 03:17:52 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, bpm.prm: REPLICAT BPM starting.
2012-10-04 03:17:52 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, bpm.prm: REPLICAT BPM started.
2012-10-04 03:17:52 INFO OGG-01562 Oracle GoldenGate Delivery for Oracle, bpm.prm: Source schema COMREFWAIT is mapped to target schema COM1REFWAIT to set the current schema for DDL execution.
2012-10-04 03:17:52 INFO OGG-01407 Oracle GoldenGate Delivery for Oracle, bpm.prm: Setting current schema for DDL operation to [COM1REFWAIT].
2012-10-04 03:17:52 ERROR OGG-00519 Oracle GoldenGate Delivery for Oracle, bpm.prm: Fatal error executing DDL replication: error [Error code [942], ORA-00942: table or view does not exist, SQL ALTER TABLE TRB1_AUDIT_SUB_LOG TRUNCATE PARTITION P2_S3008_A6000_R3 UPDATE INDEXES /* GOLDENGATE_DDL_REPLICATION */], no error handler present.
2012-10-04 03:17:52 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, bpm.prm: PROCESS ABENDING.