My Oracle Support Banner

OGG Extract Abends With ERROR OGG-00459 Cannot find metadata property DDL_MD_COL_NUM for object <table name> (Doc ID 2237840.1)

Last updated on FEBRUARY 19, 2020

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Oracle GoldenGate Capture for Oracle
Version 12.2.0.1.161018 OGGCORE_12.2.0.1.0OGGBP_PLATFORMS_160928.0200.1_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Oct 26 2016 14:24:11

Extract abends with following error

Source Context :
SourceModule : [ggdb.ora.ddl]
SourceID : [/scratch/mmar/view_storage/mmar_24513832_linux64/oggcore/OpenSys/src/gglib/ggdbora/ddloraext.c]
SourceFunction : [DDLORA_get_odbc_primary_key]
SourceLine : [1785]
ThreadBacktrace : [29] elements
: [/opt/oracle/ogg/libgglog.so(_MSG_ERR_DDL_METADATA_MISSING_OBJECT_PROPERTY
: [/opt/oracle/ogg/extract(DDLORA_get_odbc_primary_key(file_def*, DDLPropertyBuffer*, bool)+0x295) [0x70ba75]]
: [/opt/oracle/ogg/extract(DBUTIL_ddl_init_query(file_def*, short, char*, DDLPropertyBuffer*)+0x1f) [0x71678f]]
: [/opt/oracle/ogg/extract(DBUTIL_ddl_metadata_change(file_def*, ggs::gglib::ggapp::CDBObjName<(DBObjType)
: [/opt/oracle/ogg/extract(DDLEXT_getCurrentDDL(file_def*, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, int, extractDDL_t*, int)+0x45a) [0x63ec0a]]
: [/opt/oracle/ogg/extract() [0x5646e9]]

2017-01-24 22:30:16 ERROR OGG-00459 Cannot find metadata property DDL_MD_COL_NUM for object "TABLE-NAME". DDL metadata [,G1='alter index "SCHEMA-NAME"."INDEX-NAME" shrink space CHECK ',

Cause

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
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.