External Table select gets KUP-04043: table column not found in external source

(Doc ID 727906.1)

Last updated on SEPTEMBER 23, 2008

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.8
This problem can occur on any platform.

Symptoms

-- Problem Statement:

Select from an external table is showing errors:


SQL>  select * from samuraidev.sis_person_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




Cause

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