Answer by coskan ·
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.