OraFAQ Forum: Server Utilities » Character Set ID(2000)?

Home » RDBMS Server » Server Utilities » Character Set ID(2000)?

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

Character Set ID(2000)? [message #271032]

Fri, 28 September 2007 14:27

rk1_23
Messages: 17
Registered: September 2007
Location: us

Junior Member

Hi Can anyone suggest me regarding Character set Id(2000)
when i try to run my control file using sql loader
im getting the below error

Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
         
NAME                                 NEXT     *   ,  O(") CHARACTER            
BILL_CYCLE                           NEXT     *   ,  O(") CHARACTER            

           

SQL*Loader-282: Unable to locate character set handle for character set ID (2000).

and my schema is

CREATE TABLE ebt (
   name nvarchar2(35),
   bill_cycle varchar2(2),

What is this character ID? what i need to do to make it fix

Thanks in advance

[Updated on: Fri, 28 September 2007 16:22]

Report message to a moderator

Re: Character Set ID(2000)? [message #271036 is a reply to message #271032]

Fri, 28 September 2007 14:52

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL*Loader is Server Utilities, not SQL Client Tools. This is the second time you posted there, didn't you see we moved your previous post? (It is a rhetoric question, of course you saw it).

As Ana previously answered:
http://www.google.com/search?hl=en&q=SQL*Loader-282%3A+Unable+to+locate+character+set+handle+for+character+set+ID+%282000%29& btnG=Recherche+Google&meta=
Not so hard to find the answer by yourself.

Regards
Michel

[Updated on: Fri, 28 September 2007 15:02]

Report message to a moderator

Re: Character Set ID(2000)? [message #271039 is a reply to message #271032]

Fri, 28 September 2007 14:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Solution Description
--------------------
Check the permissions on the /ocommon/nls/admin/data directory and make
sure the user running these utilities can read these directories.

Report message to a moderator

Re: Character Set ID(2000)? [message #271050 is a reply to message #271039]

Fri, 28 September 2007 16:24

rk1_23
Messages: 17
Registered: September 2007
Location: us

Junior Member

Hi i have just solved the issue
just try not to use nvarchar2 unless you need it
when i replaced nvarchar2 to varchar2
my problem was solved
Anyways Thanks for all

Report message to a moderator

Previous Topic:	How to properly load CHAR from CSV file to DATE column? (split and renamed by LF and merge by MC)
Next Topic:	How to Read Data from Notepad/file and insert to the Database 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 10:07:51 CST 2024