SQL*Loader-282: Unable to locate character set handle for [message #72802] |
Thu, 23 October 2003 12:49 |
Yunjie
Messages: 1 Registered: October 2003
|
Junior Member |
|
|
I am trying to import an Excel file into an Oracle DB
and got the Loader 282 error. Other messages (on
this board) directed that could be a version issue
or enviornment issue. I tried them but didn't seem
to find the solution.
Any other hints in terms of handling this error?
Here is what I did:
i)I saved the EXCEl file as .csv (comma
deliminated): 'Questionnaire2.csv'.
wrote a control file (insert.ctl) as following:
load data
infile 'Questionnaire2.csv'
into table data
fields terminated by ','
(
ID_PROD,
divisions,
Grp,
ISBN,
title_code,
title_name,
edition,
copyright,
instock_Date,
author1,
author2,
author3
)
iii) Upload both files on the server.
iv) after SSH the server, I input the following
command:
sqlldr username/password insert
and got the SQL*Loader-282 error.
|
|
|
Re: SQL*Loader-282: Unable to locate character set handle for [message #72803 is a reply to message #72802] |
Fri, 24 October 2003 03:06 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
1. the correct syntax to use sqlldr would be
sqlldr username/password control=insert.ctl
2. Make sure u use the correct version of sqlldr against the version of database.
preferebly use the same version of sqlldr.
3. how did you move the files from windows machine to server (is that unix?)
if using ftp make sure u have set the bin option.
for scp or sftp also make sure u dont have any additional characters in the control file and in the datafile.
|
|
|