External Table Select Gets KUP-04043: table column not found in external source
(Doc ID 727906.1)
Last updated on FEBRUARY 03, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.8 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
-- Problem Statement:
Select from an external table is showing errors:
SQL> select * from <SCHEMA>.tab_external
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04043: table column not found in external source: CLASS_YEAR_NUMBER
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1
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 |