SQL*Loader-466: Column FIELD1 does not exist in table UTENTI. [message #331474] |
Thu, 03 July 2008 09:27 |
magafr
Messages: 3 Registered: July 2008
|
Junior Member |
|
|
Hello,
i'm writing you for a new information about SQL*Loader.
I have a .ctl file like this
-- sqlldr userid=xx/xx@oracle_db control=c:\tb.ctl log=c:\tb.log
LOAD DATA
INFILE 'c:\459d0MOD.tab'
APPEND
INTO TABLE Utenti
FIELDS TERMINATED BY "Tab"
( Field1,
field4,
field5,
field6,
field11,
field12,
field18)
When i execute, it gives me the following error:
SQL*Loader-466: Column FIELD1 does not exist in table UTENTI.
But as you can see in the file I have attached that Field exist in my table.
Why this? where is my error?
Thanks a lot
Francesco
-
Attachment: esempio.JPG
(Size: 34.37KB, Downloaded 1352 times)
|
|
|
|
Re: SQL*Loader-466: Column FIELD1 does not exist in table UTENTI. [message #331495 is a reply to message #331474] |
Thu, 03 July 2008 11:10 |
|
Barbara Boehmer
Messages: 9097 Registered: November 2002 Location: California, USA
|
Senior Member |
|
|
If your columns were created by enclosing them within double quotes, so that they are mixed case, like "Field1", which is a bad practice for this and other reasons, then you need to list them the same way, "Field1", in your control file. If you can, it is better to re-create the table with the field names in upper case to avoid these and other problems.
Unless your data actually looks like "dataTabdataTab..." where "Tab" is your delimiter, if you mean that it is delimited by the Tab key, then you need to use "fields terminated by x'09'".
|
|
|