OraFAQ Forum: Unix » Unable to locate character set handle for character set ID (0)

Home » Infrastructure » Unix » Unable to locate character set handle for character set ID (0)

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

Unable to locate character set handle for character set ID (0) [message #97872]

Wed, 02 April 2003 11:13

antonio castaldo
Messages: 1
Registered: April 2003

Junior Member

I'm migrating from an Oracle 7.3.3 on Solaris sun4u Ultra-Enterprise server with OS version 5.7 to Oracle 8.1.7 on Solaris sun4u Sun-Fire server with OS version 5.8. The problem is when I run my job scripts which calls SQLLDR to load records into our data warehouse. Upon trying to load I get this message: "SQL*Loader-282: Unable to locate character set handle for character set ID (0)". I never got this in Oracle 7.3.3. Can it be from differences in oracle databases or is this something more specific. Our System Admin tried some things as well as our DBA with no luck. Any idea as to where I can turn for the answer?

Thanks,
ac

Report message to a moderator

Re: Unable to locate character set handle for character set ID (0) [message #97873 is a reply to message #97872]

Wed, 02 April 2003 11:29

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

THIS IS  becuase of conflicting versions of sqlldr against the databases OR environment
always use a lower version of sqlldr against a higher version of database
or
use same the same version of sqlldr as the database.
ALSO,
MAKE SURE U HAVE ALL ENVIRONMENTS PROPERLY SET
ur PATH, ORACLE_SID,ORACLE_HOME etc AND U HAVE ACCESS PERMISSIONS.
Make sure u can invoke sqlldr from the directory ( check the PATH)
and
there are certain know bugs with oracle 7.3.3 sqlldr.
please Post more information

Report message to a moderator

Previous Topic:	help
Next Topic:	SOLUTION PLEAse

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 03 11:03:17 CDT 2026