Home » RDBMS Server » Server Utilities » Character Set ID(2000)?
Character Set ID(2000)? [message #271032] Fri, 28 September 2007 14:27 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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.
Re: Character Set ID(2000)? [message #271050 is a reply to message #271039] Fri, 28 September 2007 16:24 Go to previous message
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
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:
  


Current Time: Fri Dec 09 15:23:02 CST 2016

Total time taken to generate the page: 0.24933 seconds