Hi,
Actually, although this was included on Oracle 8i, it can be used on Oracle
8, look for some notes on Metalink regarding this. Oracle does recomend you
export and recreate your database, but if it is not possible to recreate the
DB it can be done. The new character set must be a superset of the old one.

I did this same character set change on a 8.0.4 database last week, and
there was no problem, but I changed from US7ASCII to WE8ISO8859P1 not to
WE8ISO885P1...

HTH,
Patricia.


-----Original Message-----
From: Ofer Harel [mailto:[Email Address Removed] Terça-feira, 30 de Abril de 2002 11:35
To: LazyDBA.com Discussion
Subject: RE: character set conversion in 8.0.5.0.1


Unfortunately you cannot change character set in that way.
from Oracle's document:

@ In Oracle 8.1 an undocumented option INTERNAL_USE has been added to
@ the ALTER DATABASE [NATIONAL] CHARACTER SET command:
@
@ ALTER DATABASE [<db_name>]
@ [NATIONAL] CHARACTER SET INTERNAL_USE <new_character_set>
@
@ If included in the statement this option will switch the character set
@ verification off allowing any database character set to be changed.
@
@ NOTE: The INTERNAL_USE option should only be used under guidance from
@ ==== Oracle Support Services and only if its effects on the database
@ are well understood. Improper use of the option can lead to
@ corruption of the database.

since you are using Oracle 8.0.5 you should use another strategy.

export database in old nls_lang
create another database with new nls_lang
change environment (registry) nls_lang parameter
import to the new database
pray

HTH
regards

Ofer Harel
DBA team
Barak ITC
[Email Address Removed] Message-----
From: Jegatheesan, Srinvasan (CSC) [mailto:[Email Address Removed] Tuesday, April 30, 2002 3:26 PM
To: LazyDBA.com Discussion
Subject: characterset conversion in 8.0.5.0.1


Hi All

We are using oracle 8.0.5.0.1 database with US7ASCII character set. we need
to change US7ASCII to WE8IS0885P1 character set to support foreign
languages. Following is the script i used

shutdown immediate;
startup mount;
alter database enable restricted session;
alter system set job_queue_processes=0;
alter system set aq_tm_procsses=0;
alter database open;
alter database set character set WE8IS0885P1;

But i'm getting the following error message:

ORA-12710: new character set must be a superset of old character set
ALTER DATABASE NATIONAL CHARACTER SET WE8IS0885P1

Any help on this would be greatly appreciated.

regards
srini J


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page