OraFAQ Forum: Server Administration » How can I change character set of existing Oracle DB (11g)

Home » RDBMS Server » Server Administration » How can I change character set of existing Oracle DB (11g) (Oracle 11g DB on linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can I change character set of existing Oracle DB (11g) [message #333970]

Tue, 15 July 2008 01:30

slee72890
Messages: 3
Registered: July 2008

Junior Member

My current Oracle 11g DB has a character set of WE8MSWIN1252. I need to change it to AL32UTF8. I tried to use:

ALTER DATABASE CHARACTER SET AL32UTF8;

This gave me an error that change cannot be done from WE8MSWIN1252 to AL32UTF8. What else can I do to make this character set change?

If at worst, I need to reinstall my DB, what method is best to save my current data (e.g. export/import, etc.)?

Thanks for your help,

slee

Report message to a moderator