Can anybody tell me, whether we can change the CHARACTERSET of a database. If yes then please explain me the way ?
I don't know your DB version
Please refer to MOS note [ID 234381.1]
Basically it could be done for versions up to 8i this option looks still available but Oracle says do not do it and create database again with right characterset and do export import. Data loss is highly possible if you go 8i way.
No one has followed this question yet.