Database Administration (MOSC)

MOSC Banner

Change database character set

edited Apr 7, 2010 1:39AM in Database Administration (MOSC) 6 commentsAnswered
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center