Replicat Is Not Working while processing DDL transactions in OGG 18.104.22.168.33
(Doc ID 2425840.1)
Last updated on DECEMBER 03, 2020
Applies to:Oracle GoldenGate - Version 22.214.171.124.33 and later
Information in this document applies to any platform.
We have issue in replicate side, where goldengate is giving a interesting error: even though table exists but still giving a error.
2018-01-22 10:51:37 ERROR OGG-00519 Oracle GoldenGate Delivery for Oracle, <REPNAME>.prm: Fatal error executing DDL replication: error [Error code , ORA-00942: table or view does not exist SQL ALTER TABLE <SCHEMA>."<TABLENAME" ADD CONSTRAINT <CONSTRAINT NAME>
FOREIGN KEY (<COLUMN NAME>)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document