Home » RDBMS Server » Server Utilities » CSSCAN
CSSCAN [message #275306] Fri, 19 October 2007 06:39 Go to next message
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
Re: CSSCAN [message #275308 is a reply to message #275306] Fri, 19 October 2007 06:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: CSSCAN [message #275515 is a reply to message #275306] Sat, 20 October 2007 23:59 Go to previous messageGo to next message
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
Re: CSSCAN [message #275524 is a reply to message #275515] Sun, 21 October 2007 01:11 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, use UTF8 instead of AL32UTF8 in your CSSCAN command.

Regards
Michel
Previous Topic: Select Table For Export
Next Topic: Help about Sql loader
Goto Forum:
  


Current Time: Sun Dec 04 08:19:32 CST 2016

Total time taken to generate the page: 0.07093 seconds