GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

ORA-26786 And ORA-26787 in Unidirectional Repication

edited Jan 17, 2016 9:21PM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered ✓

Hello,

After setting up oracle streams, actually the replication works, the transaction from master DB is replicated to replica DB. But I'm curious why ORA-26786 and ORA-26787 still occur in this unidirectional streams replication. As there's no update in destination database, in theory (AFAIK) this couldn't be happen. This is schema replication.

Oracle DB version: 11gR2

1st DB configuration (master):

SUPPLEMENTAL_LOG_DATA_MIN     : YES

SUPPLEMENTAL_LOG_DATA_PK       : YES

SUPPLEMENTAL_LOG_DATA_UI        : YES

SUPPLEMENTAL_LOG_DATA_FK       : YES

SUPPLEMENTAL_LOG_DATA_ALL     : YES

SUPPLEMENTAL_LOG_DATA_PL        : NO

FORCE_LOGGING                                     : YES

2nd DB configuration (destination):

SUPPLEMENTAL_LOG_DATA_MIN     : NO

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center