OGG Triggerless Integrated Extract Abends With Error on DDL Trigger related tables when DDL is enabled
Last updated on FEBRUARY 06, 2017
Applies to:Oracle GoldenGate - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
On : 22.214.171.124.0 version, 1 - Oracle DB backend
When running Integrated Extract on Oracle V126.96.36.199 or higher, taking the advantage of trigger-less DDL capture. See errors below
2013-11-08 11:52:41 ERROR OGG-02636 Oracle GoldenGate Capture for Oracle, e11bdmig.prm: The TABLE specification 'TABLE GGSUSER.GGS_MAR
KER' for the source table GGSUSER.GGS_MARKER does not include a catalog name. The database requires a catalog name.
2013-11-08 11:52:41 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, e11bdmig.prm: PROCESS ABENDING.
2013-11-08 11:52:44 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (moggbrdb): info all.
2. Sometimes, the error shows
2015-01-26 15:05:32 ERROR OGG-00529 DDL Replication is enabled but table OGG.GGS_DDL_HIST is not found. Please check DDL installation in the database.
DDL trigger is not installed as DDL trigger is not required for Integrated extract when database version is 188.8.131.52. and higher
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms