Home » RDBMS Server » Server Administration » database characterset migration from WE8DEC to UTF8
database characterset migration from WE8DEC to UTF8 [message #305545] Tue, 11 March 2008 04:28 Go to next message
orcl dba
Messages: 68
Registered: August 2005
Member
Hi all,

We are planning to migrate our database characterset from WE8DEC to UTF8. Are there any tools available to accomplish this with minimum downtime? What is the best practice to do it?

Database version: 10.2.0.2
OS: SuSE 10.1
Re: database characterset migration from WE8DEC to UTF8 [message #305551 is a reply to message #305545] Tue, 11 March 2008 04:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
export full
recreate the database with new character set
import full

You can also read Database Globalization Support Guide, Chapter 11 Character Set Migration and maybe use the CSALTER script.

Regards
Michel

[Updated on: Tue, 11 March 2008 04:42]

Report message to a moderator

Re: database characterset migration from WE8DEC to UTF8 [message #305657 is a reply to message #305551] Tue, 11 March 2008 08:29 Go to previous messageGo to next message
orcl dba
Messages: 68
Registered: August 2005
Member
Thanks for getting back to me.
CSALTER can be used only if all of the data is a strict subset of the new character set. I dont think UTF8 is a superset of WE8DEC. Correct me if I am wrong.
Re: database characterset migration from WE8DEC to UTF8 [message #305659 is a reply to message #305657] Tue, 11 March 2008 08:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
UTF8 is a superset of US7ASCII and nothing more.

[Edit:] CSALTER is NOT the same as ALTER DATABASE SET CHARACTER SET, if this is what you were thinking of.

Now it depends on your actual data.
If CSALTER does not work in your case, the first way I gave will.

Regards
Michel

[Updated on: Tue, 11 March 2008 08:34]

Report message to a moderator

Re: database characterset migration from WE8DEC to UTF8 [message #305669 is a reply to message #305659] Tue, 11 March 2008 08:53 Go to previous messageGo to next message
orcl dba
Messages: 68
Registered: August 2005
Member
I know the export/import would work. Is there any other tool(might come with a cost) which facilitates this in lesser time? Also would the expdp/impdp utilities be faster than the traditional exp/imp utilities?
Re: database characterset migration from WE8DEC to UTF8 [message #305672 is a reply to message #305669] Tue, 11 March 2008 09:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
CSALTER is the only alternative tool.
It depends on your environment, read Original Export and Import Versus Data Pump Export and Import

Regards
Michel
Re: database characterset migration from WE8DEC to UTF8 [message #305855 is a reply to message #305672] Wed, 12 March 2008 03:57 Go to previous messageGo to next message
orcl dba
Messages: 68
Registered: August 2005
Member
According to Oracle documentation(chapter 11 Character Set Migration),

"Migrating a Character Set Using the CSALTER Script

The CSALTER script is part of the Database Character Set Scanner utility. The CSALTER script is the most straightforward way to migrate a character set, but it can be used ONLY IF ALL OF THE SCHEMA DATA IS A STRICT SUBSET OF THE NEW CHARACTER SET.
The new character set is a strict superset of the current character set if:
* Each and every character in the current character set is available in the new character set.
* Each and every character in the current character set has the same code point value in the new character set. For example, many character sets are strict supersets of US7ASCII. "

Re: database characterset migration from WE8DEC to UTF8 [message #305859 is a reply to message #305855] Wed, 12 March 2008 04:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes and what is your point?

You may not have a strict character subset but have DATA that are in a strict character subset. This is the purpose of CSALTER to help you in this case.

Regards
Michel

[Updated on: Wed, 12 March 2008 04:03]

Report message to a moderator

Re: database characterset migration from WE8DEC to UTF8 [message #306258 is a reply to message #305545] Thu, 13 March 2008 08:35 Go to previous message
orcl dba
Messages: 68
Registered: August 2005
Member
Is anyone aware of some third party tools available for character set migration?
Previous Topic: error in adding initialization parameters
Next Topic: how to delete the duplicated triggers.
Goto Forum:
  


Current Time: Sun Dec 11 00:22:57 CST 2016

Total time taken to generate the page: 0.04609 seconds