OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » CSSCAN

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

CSSCAN [message #275306]

Fri, 19 October 2007 06:39

ram_ocp
Messages: 49
Registered: December 2005
Location: Karnataka

Member

Hi,

My Oracle database is 8.1.7.4
Characterset is WE8ISO8859P1
I need to convert to AL32UTF8

But before that when i test with CSSCAN i get the following error

Y:\>CSSCAN SYSTEM/system FULL=y TOCHAR=AL32UTF8 ARRAY=102400 PROCESS=3


Character Set Scanner: Release 8.1.7.0.0 - Production on Fri Oct 19 17:06:30 200
7

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

CSS-00115: invalid character set name AL32UTF8

Scanner terminated unsuccessfully.

Please let me know what can be done

Ram

Report message to a moderator

Re: CSSCAN [message #275308 is a reply to message #275306]

Fri, 19 October 2007 06:53

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

8.1.7 does not know AL32UTF8, it just knows the old UTF8.
If you want to convert to AL32UTF8 you need to first upgrade to at least 9.2 (but better 10.2).

Regards
Michel

Report message to a moderator

Re: CSSCAN [message #275515 is a reply to message #275306]

Sat, 20 October 2007 23:59

ram_ocp
Messages: 49
Registered: December 2005
Location: Karnataka

Member

Hi,

Thanks for clearing my doubt.
Yes i need to migrate to 9i or 10g and then import the data.

But is there any way that i check the data for any incompatibility before importing.
Would CSSCAN with utf8 will be of help?

Ram

Report message to a moderator

Re: CSSCAN [message #275524 is a reply to message #275515]

Sun, 21 October 2007 01:11

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Yes, use UTF8 instead of AL32UTF8 in your CSSCAN command.

Regards
Michel

Report message to a moderator

Previous Topic:	Select Table For Export
Next Topic:	Help about Sql loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 28 15:44:55 CDT 2024