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 LazyDBA home page