Only Insert statement working,update and delete statement executed then Replicat will Abended
EDIT PARAM EORA01
EXTRACT EORA01
SETENV (ORACLE_SID="TARBR")
SETENV (ORACLE_HOME = "/bugmnt10/am/celclnx14/SR3.6008695737/app/oracle/product/11.2.0.2")
USERID ggadmin, PASSWORD ggadmin
EXTTRAIL ./dirdat/lt
DYNAMICRESOLUTION
-- DDL INCLUDE MAPPED OBJNAME SOURCE.* -- Optional, you will need to enable DDL replication support otherwise you will get OGG-00529
TABLE SOURCE.TCUSTMER;
TABLE SOURCE.TCUSTORD;
Target:
EDIT PARAM RORA01
REPLICAT RORA01
SETENV (ORACLE_SID="TARBR2")
USERID ggadmin, PASSWORD ggadmin
HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/RORA01.DSC, PURGE
MAP SOURCE.tcustmer, TARGET TARGET.tcustmer;
MAP SOURCE.tcustord, TARGET TARGET.tcustord;
ggsce.log error
No unique key is defined for table 'TCUSTORD'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.