Home » RDBMS Server » Server Utilities » SQL*Load (merged)
SQL*Load (merged) [message #259620] Thu, 16 August 2007 02:25 Go to next message
vikram_srivastava
Messages: 5
Registered: August 2007
Location: Pune
Junior Member
Hi All
I am trying to load data through SQL Loader.I am doing this in client desktop where Oracle 8.1.6 is there,and Oracle Server is 7.3. I am getting the following error.

SQL*Loader-282: Unable to locate character set handle for character set ID (0) . Please provide me solution of this problem.

Thanks a ton an advance!!!

Warm Regards
Vikram

Re: Sql Loader Error [message #259633 is a reply to message #259620] Thu, 16 August 2007 02:41 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle
SQL*Loader-00282 Unable to locate character set handle for character set ID (number).

Cause: SQL*Loader could not find the character set handle for the given character set ID.

Action: The character set ID was obtained from the database server, the SQL*Loader client does not have knowledge of the given character set ID. Possible mismatch of NLS data on the client and server side.

Re: Sql Loader Error [message #259642 is a reply to message #259633] Thu, 16 August 2007 02:57 Go to previous messageGo to next message
vikram_srivastava
Messages: 5
Registered: August 2007
Location: Pune
Junior Member
Hi
Can u please tell me how do I match the NLS parameter of client and server. Is it like a possibility that oracle 8.1 client can not load the data in Oracle 7.3 db through SQL Loader.

Thanks & Regards
Vikram
Re: Sql Loader Error [message #259652 is a reply to message #259642] Thu, 16 August 2007 03:22 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Do you have the NLS_LANG environment variable set? If so, what is its value?

What is the result of "select * from v$nls_parameters" statement?
Script for data loading [message #259686 is a reply to message #259620] Thu, 16 August 2007 04:40 Go to previous messageGo to next message
vikram_srivastava
Messages: 5
Registered: August 2007
Location: Pune
Junior Member
Hi All
I want to load some data in database tables.I am doing this from client desktop. The client is Oracle 8.1 and the server is oracle 7.3, It gave me following error--
SQL*Loader-282: Unable to locate character set handle for character set ID (0).
How can I write a pl/sql script that can read a | delimited text file (more than one row), and then can insert that data into a database table.I am new to the pl/sql field,So any pointer is highly appreciated.

Thnnks a ton in advance!!!

Warm Regards
Vikram


Re: Script for data loading [message #259690 is a reply to message #259686] Thu, 16 August 2007 04:47 Go to previous messageGo to next message
pandya
Messages: 7
Registered: August 2007
Junior Member
Is the txt file on the same machine as your database ?
Re: Script for data loading [message #259695 is a reply to message #259690] Thu, 16 August 2007 04:56 Go to previous messageGo to next message
vikram_srivastava
Messages: 5
Registered: August 2007
Location: Pune
Junior Member
No text file is in my machine(client), But I am having the acces I can put tha file in server machine too, no issues..
Re: Script for data loading [message #259699 is a reply to message #259695] Thu, 16 August 2007 05:01 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If you have access to the server (and you've said you have), why don't you do so and load the file using 7.3 SQL*Loader (which would also resolve your problems of this kind).
Re: Script for data loading [message #259703 is a reply to message #259699] Thu, 16 August 2007 05:10 Go to previous messageGo to next message
vikram_srivastava
Messages: 5
Registered: August 2007
Location: Pune
Junior Member
that is what I have mentioned in the beginning what Error I am getting when using SQL Loader. since client is oracle 8.1 hence I am having only SQLLDR not SQLLDR73. And I am having access for reading and writing a particaular folder of that machine where I can put the text file.
Re: Script for data loading [message #259776 is a reply to message #259703] Thu, 16 August 2007 08:14 Go to previous message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
But you said you have access to the server. Run SQL*Loader from there. Copy the file to the server, connect to the server and run it all from there.
Previous Topic: raw disks and file system
Next Topic: help needed with sqlldr
Goto Forum:
  


Current Time: Sat Dec 10 18:20:03 CST 2016

Total time taken to generate the page: 0.15989 seconds