Change Database Character-set and National Character-set:After installing Oracle Database Version 8.1.7 and above it
is possible to change the Character set of the database.
Assuming that the Database does not contain Important Data or Contains
only English Language Characters It is possible to use the following script in order to change the Character set and National Character set.The word
internal_use in the script is essential only when changeing between sets that dont belong to the same familliy.By writting
internal_use it is possible to switch between Any Character set to Any Other.
The Script:connect sys as sysdba
--------------------------------------------------------
-- these parameters have to be changed
-- in order to change characterset
--------------------------------------------------------
Alter system set job_queue_processes=0 scope=spfile;
Alter system set aq_tm_processes=0 scope=spfile;
shutdown immediate
startup nomount
alter database mount exclusive;
alter database open;
alter system enable restricted session;
purge dba_recyclebin;
alter database character set internal_use AL32UTF8;
alter database national character set internal_use UTF8;
shutdown immediate
startup
