DB Patches Needed to Support SCHEMATRANDATA in OGG (Oracle GoldenGate)
(Doc ID 1426440.1)
Last updated on MARCH 13, 2019
Applies to:Oracle GoldenGate - Version 126.96.36.199.1 and later
Information in this document applies to any platform.
DB Version is 188.8.131.52.0 and ADD SCHEMATRANDATA fails with following error
GGSCI> DBLOGIN USERID <GGUSER> password <PASSWORD>
Successfully logged into database.
GGSCI> ADD SCHEMATRANDATA <SCHEMANAME>
2012-02-17 15:11:42 ERROR OGG-01783 Cannot verify existence of table function that is required to enable schema level supplemental logging, failed to find function.
DB Version is 184.108.40.206, using SCHEMATRANDATA. ADD SCHEMATRANDATA works fine. Table has multiple unique indexes, no primary key. Extract captures NULL for the unique index columns that aren't supposed to have NULL value.
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