OraFAQ Forum: Server Administration » database characterset migration from WE8DEC to UTF8

Home » RDBMS Server » Server Administration » database characterset migration from WE8DEC to UTF8

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

database characterset migration from WE8DEC to UTF8 [message #305545]

Tue, 11 March 2008 04:28

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

Report message to a moderator

Re: database characterset migration from WE8DEC to UTF8 [message #305551 is a reply to message #305545]

Tue, 11 March 2008 04:41

Michel Cadot
Messages: 68684
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

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.

Report message to a moderator

Re: database characterset migration from WE8DEC to UTF8 [message #305659 is a reply to message #305657]

Tue, 11 March 2008 08:32

Michel Cadot
Messages: 68684
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

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?

Report message to a moderator

Re: database characterset migration from WE8DEC to UTF8 [message #305672 is a reply to message #305669]

Tue, 11 March 2008 09:10

Michel Cadot
Messages: 68684
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

Report message to a moderator

Re: database characterset migration from WE8DEC to UTF8 [message #305855 is a reply to message #305672]

Wed, 12 March 2008 03:57

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. "

Report message to a moderator

Re: database characterset migration from WE8DEC to UTF8 [message #305859 is a reply to message #305855]

Wed, 12 March 2008 04:03

Michel Cadot
Messages: 68684
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

orcl dba
Messages: 68
Registered: August 2005

Member

Is anyone aware of some third party tools available for character set migration?

Report message to a moderator

Previous Topic:	error in adding initialization parameters
Next Topic:	how to delete the duplicated triggers.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 16 21:58:40 CDT 2024