Decide the character set you want to change and check whether new character is superset of old character set
1.SQL> shutdown immediate
2.SQL> startup open restrict
3.SQL> alter database character set internal_use UTF8;
4.SQL> shutdown immediate
5.SQL> startup
Refer the following Metalink Note for more details:
Note 225912.1 Changing the Database Character Set - a short overview
Note 227330.1 Character Sets & Conversion - Frequently Asked Questions
1 comment:
Nandakumar,
I feel that above method is not supported for 10g database. For 10g , you need to use csalter script to change characterset.
Also for 9i also , you should be running csscan tool otherwise using this command will lead to data loss..
Cheers
Amit
Post a Comment