Home » RDBMS Server » Server Utilities » sqlldr invalid column name
sqlldr invalid column name [message #69515] Thu, 24 January 2002 05:29 Go to next message
Tim
Messages: 49
Registered: October 2000
Member
I am getting an invalid column name error even though that column exists in my table.
Here is my control file:

LOAD DATA

INFILE 'w_survey.txt'

APPEND

INTO TABLE warehouse.lake_survey

FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'

(
YEAR,
WATER_DOW,
SURVEY_DATE DATE "mm/dd/yyyy",
TYPE "UPPER(TYPE)",
CHEM_SAMP_DATE DATE "mm/dd/yyyy" "chk_date(SURVEY_DATE)" ,
SECCHI_FT,
PH,
ALKALINITY,
COLOR,
TOT_PHOSPHOROUS,
TOT_DISSLVD_SOLIDS,
CHLOROPHYLL,
CONDUCTIVITY,
NO_TRANSECTS,
MAX_DEPTH,
HAB_BEGIN_DATE,
HAB_END_DATE

)

Here is the error it generates:
Record 1: Rejected - Error on table WAREHOUSE.LAKE_SURVEY, column CHEM_SAMP_DATE.
ORA-00904: invalid column name
Re: sqlldr invalid column name [message #69522 is a reply to message #69515] Fri, 25 January 2002 04:27 Go to previous message
Ajay Gandhi
Messages: 14
Registered: January 2002
Junior Member
I believe there is a syntax issue in the ctl file. Try removing the extra functions after the TYPE column and the CHEm_SAMP_DATE and see if it works.

Previous Topic: error on migrate from 7.3 to 8i
Next Topic: Re: OCP Exam Papers
Goto Forum:
  


Current Time: Mon Mar 04 16:24:31 CST 2024