how golden gate DDL replicate is interpreting create table as select * from other_table where rownum
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.