GoldenGate Replicat Abends With ORA-38802: edition does not exist SQL ALTER SESSION SET EDITION="V_XXXXXXXX_XXXX"
(Doc ID 2536542.1)
Last updated on DECEMBER 15, 2019
Applies to:Oracle GoldenGate - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Integrated Replicat abend with OGG-06532 due to ORA-38802 while executing Grants, source DB was Editioned db and target db was NON-Editioned db
2019-03-26T19:09:31.631-0400 ERROR OGG-06545 Oracle GoldenGate Delivery for Oracle, <rep_name>.prm: Failed to switch to edition V_20180920_0813 before applying the following DDL: <DDL>/* GOLDENGATE_DDL_REPLICATION */ (size 94).
2019-03-26T19:09:31.633-0400 ERROR OGG-06532 Oracle GoldenGate Delivery for Oracle, <rep_name>.prm: Failed to switch to Edition V_20180920_0813. OCI Error ORA-38802: edition does not exist SQL ALTER SESSION SET EDITION="V_20180920_0813" (status = 38802), SQL .
Since edition "V_20180920_0813" does not exist on target database, we'd like to ignore or discard this transaction
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