SQLLoader throws ORA-00984: Column Not Allowed Here
Last updated on JULY 02, 2015
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
Using the control file:
INTO TABLE CCAR_SOURCE.T_QRM_REF_FORECAST_14A_STG
FIELDS TERMINATED BY ',' optionally enclosed by '"'
to load the data into a table the following error is reported by SQL*Loader:
FILE_NM "STI_Adverse" column is causing the error. The load works fine Without "_".
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