Home » RDBMS Server » Server Utilities » SQL*Loader-466: Column FIELD1 does not exist in table UTENTI.
SQL*Loader-466: Column FIELD1 does not exist in table UTENTI. [message #331474] Thu, 03 July 2008 09:27 Go to next message
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 364 times)
Re: SQL*Loader-466: Column FIELD1 does not exist in table UTENTI. [message #331475 is a reply to message #331474] Thu, 03 July 2008 09:29 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Please read & follow Posting Guidelines below
http://www.orafaq.com/forum/t/88153/0/

When in doubt, BELIEVE the error message!

[Updated on: Thu, 03 July 2008 09:30] by Moderator

Report message to a moderator

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 Go to previous message
Barbara Boehmer
Messages: 8636
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'".
Previous Topic: Is it possible to import only the master tables?
Next Topic: stats_pack results
Goto Forum:
  


Current Time: Fri Dec 09 21:35:41 CST 2016

Total time taken to generate the page: 0.07527 seconds