This content has been marked as final. Show 5 replies
Actually the error is
ERROR OGG-01296 Error mapping from PROD.f0911 to PROD.f0911 .
Why would you add that "macro" there? Just make it as part of the mapping
As per our requirement if there is "0001 -unique constraint violated" error while replication the insert record should be update in target table .So I have used
UPDATEINSERT statement iin macro and it goes to the same main table but for others it has mapped to EXCEPTION table prodf0911_EI , so the record will go to exception table .But we need the record should go to main table and insert record should update in target table only in case of 0001 - unique key constraint violated error.
*;* is required at the end of the MAP statement.
In your case define the macro as follows:
Thanks for the responce .I had tried this also but the same error .