SQLLoader throws ORA-00984: Column Not Allowed Here (Doc ID 2026799.1)

Last updated on JULY 02, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Using the control file:

LOAD DATA
INFILE 'G:\loadfiles\outbound\Forecast\STI_Adverse.TXT'
BADFILE '%BAD_FILE%'
DISCARDFILE '%DIS_FILE%'
REPLACE
INTO TABLE CCAR_SOURCE.T_QRM_REF_FORECAST_14A_STG
FIELDS TERMINATED BY ',' optionally enclosed by '"'
TRAILING NULLCOLS
(
SUBLOB,
LOB,
ACCOUNT,
ACCOUNT_TYPE,
TRANSACTION_ID,
PROPERTY,
BREAKOUT,
FLATPERIODUS,
PERIOD,
VALUE,
IDB_CREAT_TS "SYSTIMESTAMP",
FILE_NM "STI_Adverse"
)


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 "_".

 

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