GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

how golden gate DDL replicate is interpreting create table as select * from other_table where rownum

edited Jun 22, 2020 12:12PM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered ✓

Hello Gurus ,

I have a scenario where I have DDL and DML replication enabled .I have created a table with statement create table schema_name.TEST as select * from sys.dba_objects where rownum<100 . It was successfully replicated at target .

Now when I deleted a record from the target table schema_name.TEST , this caused the replicate at source to abended  with mapping error . Is this because of rownum?

2020-06-21T21:18:01.795-0500  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, r_ggtest.prm:  SQL error 1403 mapping PDB. schema_name.TEST to PDB. schema_name.TEST No data found.
2020-06-21T21:18:01.876-0500  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, r_ggtest.prm:  Error mapping from PDB. schema_name.TEST to PDB. schema_name.TEST.

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