SQL*Loader troubles [message #21269] |
Mon, 22 July 2002 13:33 |
Tom C.
Messages: 1 Registered: July 2002
|
Junior Member |
|
|
I'm trying to load data from a .csv file using SQL loader.
In SQL*Plus:
SQL> describe PDATA
Name Null? Type
----------------------------------------- -------- ----------------------------
FFNum NOT NULL NUMBER(5)
Last NOT NULL VARCHAR2(30)
First NOT NULL VARCHAR2(15)
Address NOT NULL VARCHAR2(100)
City NOT NULL VARCHAR2(30)
State NOT NULL VARCHAR2(2)
Zip NOT NULL NUMBER(5)
Phone VARCHAR2(13)
Okay, so far so good. My control file looks like this:
LOAD DATA
INFILE 'pdata.csv'
INTO TABLE PDATA
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
( FFNum, Last, First, Address, City, State, Zip, Phone )
From the DOS prompt, I run SQLLDR like this:
sqlldr SYSTEM/password@METCS579 control=579db2.ctl
The result?
"SQL*Loader-466: Column FFNUM does not exist in table PDATA."
What is going on? Of course it exists.
|
|
|
|