GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Two issues in my replication environment

edited Mar 21, 2014 8:24AM in GoldenGate, Streams and Distributed Database (MOSC) 17 commentsAnswered ✓

Hello,

I have to issues that happened during last weekend in my GoldenGate replication environment. I have some doubts about how to safely cope  with them and I'd like to know about similar experiences and how did you solve them.

CASE 1
======

1) Source/Target tables are identical: no PK/UK
2) trandata available/captured for all the columns of the table
3) Extract resolved as wildcard SCHEMA.*
4) Replicat resolved as SCHEMA.*
5) Got the error "OGG-01168  Encountered an update for target table SCHEMA.TABLE, which has no unique key defined.  KEYCOLS can be used to define a key.  Use ALLOWNOOPUPDATES to process the update without applying it to the target database.  Use APPLY NOOPUPDATES to force the update to be applied using all columns in both the SET and WHERE clause."

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center