Extract Abended After Conversion From Classic To Integrat With " OCI Error ORA-00904: "INTCOL#": invalid identifier "
(Doc ID 2539175.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle GoldenGate - Version 12.3.0.1.3 and laterInformation 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.
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |