My Oracle Support Banner

Extract Abended After Conversion From Classic To Integrat With " OCI Error ORA-00904: "INTCOL#": invalid identifier " (Doc ID 2539175.1)

Last updated on MARCH 12, 2021

Applies to:

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

Symptoms

Extract abended after conversion from classic to integrated with error below :

Error :

2018-12-15 02:39:01 ERROR OGG-00663 OCI Error ORA-00904: "INTCOL#": invalid identifier
(status = 904), SQL <SELECT md_col_name, md_col_num, md_col_segcol, md_col_type, md_col_len, md_col_prec, md_col_scale, md_col_charsetid, md_col_charsetform, md_col_alt_type,
md_col_alt_prec, md_col_alt_char_used, md_col_alt_length, md_col_alt_type_owner, property, xopqtypeflags , intcol# FROM TABLE (system.logmnr$col_gg_tabf_public(
:sid, :mdh, :object_id, :objv, to_number(:csn) ))>.

Source Context :
SourceModule : [er.redo.ora.IXFormatter]
SourceMethod : [getResult]
SourceLine : [748]

2018-12-15 02:39:01 ERROR OGG-02078 Extract encountered a fatal error in a processing thread and is abending.

 

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
References


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