Home » RDBMS Server » Server Administration » How can I change character set of existing Oracle DB (11g) (Oracle 11g DB on linux)
How can I change character set of existing Oracle DB (11g) [message #333970] Tue, 15 July 2008 01:30 Go to next message
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
Re: How can I change character set of existing Oracle DB (11g) [message #333978 is a reply to message #333970] Tue, 15 July 2008 01:55 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to export/recreate the database/import.

Regards
Michel
Previous Topic: ORA-02049: timeout: distributed transaction waiting for lock
Next Topic: Oracle DIRECTORY object
Goto Forum:
  


Current Time: Tue Dec 06 15:53:42 CST 2016

Total time taken to generate the page: 0.15759 seconds