Re: sql*loader-282 error

I had a similar error trying to load data into a 7.3.4 instance with an 8.0.5 sqlloader.

The resolution: Go to metalink and read about it. Essentially, you need to use the SQLLoader/Oracle utilities that were included with the database. What I did was reran the Oracle installer for 7.3.4 and installed the Oracle Utilities, along with the Product docs, TCP/IP, SQL*NEt and required support files. Then, I added the TNS entry for the instance I wanted to connect to and OILA, it worked.

Note that my oracle client was an 805 installation in \orant and I wrote to that same home. I had an 815 client in ora815 (ora815_home), and the 6i tools in d:\ora6idev (ora6idev_home).

Goood luck.

robertmew_at_my-deja.com wrote in message <8isn5n$120$1_at_nnrp2.deja.com>...
>Hi
>
>I'm having problems sql*loading from a 8.1.5
>client into a 7.3.3.4 server.
>
>I keep getting;
>SQL*Loader-282: Unable to locate character set
>handle for character set ID (0)
>
>I've used 'characterset' keyword to correct this
>but the same srror occurs.
>
>Can anyone help?
Received on Fri Jun 30 2000 - 00:00:00 CEST