Change database character set
Hi, experts. I have database 10g R2 and win(64 bit) OS. I want change database character set from WE8MSWIN1252 to AL32UTF8. i know that can every character in table have 1 byte, but AL32UTF8 can have 3 or 4 byte. all my tables owner is myuser schema. It is know that can not change character set "alter database character set AL32UTF8", there are several methods to changing character set but i do not want create new db with AL32UTF8 character set and migrate data. That is true which I perfoming following:
1. backup full db
2.export myuser schema
3.drop myuser and recreate
1. backup full db
2.export myuser schema
3.drop myuser and recreate
0