OraFAQ Forum: Server Utilities » SQL*Load (merged)

Home » RDBMS Server » Server Utilities » SQL*Load (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL*Load (merged) [message #259620]

Thu, 16 August 2007 02:25

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

Report message to a moderator

Re: Sql Loader Error [message #259633 is a reply to message #259620]

Thu, 16 August 2007 02:41

Littlefoot
Messages: 21811
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.

Report message to a moderator

Re: Sql Loader Error [message #259642 is a reply to message #259633]

Thu, 16 August 2007 02:57

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

Report message to a moderator

Re: Sql Loader Error [message #259652 is a reply to message #259642]

Thu, 16 August 2007 03:22

Littlefoot
Messages: 21811
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?

Report message to a moderator

Script for data loading [message #259686 is a reply to message #259620]

Thu, 16 August 2007 04:40

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

Report message to a moderator

Re: Script for data loading [message #259690 is a reply to message #259686]

Thu, 16 August 2007 04:47

pandya
Messages: 7
Registered: August 2007

Junior Member

Is the txt file on the same machine as your database ?

Report message to a moderator

Re: Script for data loading [message #259695 is a reply to message #259690]

Thu, 16 August 2007 04:56

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..

Report message to a moderator

Re: Script for data loading [message #259699 is a reply to message #259695]

Thu, 16 August 2007 05:01

Littlefoot
Messages: 21811
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).

Report message to a moderator

Re: Script for data loading [message #259703 is a reply to message #259699]

Thu, 16 August 2007 05:10

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.

Report message to a moderator

Re: Script for data loading [message #259776 is a reply to message #259703]

Thu, 16 August 2007 08:14

joy_division
Messages: 4963
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.

Report message to a moderator

Previous Topic:	raw disks and file system
Next Topic:	help needed with sqlldr

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 02 05:30:17 CDT 2024