OraFAQ Forum: Server Administration » character set conversion

Home » RDBMS Server » Server Administration » character set conversion (11g on windows)

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

character set conversion [message #475143]

Mon, 13 September 2010 05:21

gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai

Member

Hi,

we have to migrate data from 11.1.0.6.0 to 11.2.0.1.0

Version : 11.1.0.6.0 character set : WE8MSWIN1252

Version : 11.2.0.1.0 character set : AL32UTF8

Any hints with which we can go.

Thanks in Advance

Report message to a moderator

Re: character set conversion [message #475153 is a reply to message #475143]

Mon, 13 September 2010 06:25

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Read the Upgrade manual but the only way is export/import.

Regards
Michel

[Updated on: Mon, 13 September 2010 06:25]

Report message to a moderator

Re: character set conversion [message #475163 is a reply to message #475153]

Mon, 13 September 2010 06:56

gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai

Member

Thanks for quick reply.

So in this case we have to take manually export and then import it in new database??

But how the character set gets changed.
(may be i am not aware of it, so asking)

Thanks again in Advance.

Report message to a moderator

Re: character set conversion [message #475176 is a reply to message #475163]

Mon, 13 September 2010 08:05

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

But how the character set gets changed

Because you create the new one with the new character set.

Regards
Michel

Report message to a moderator

Previous Topic:	ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
Next Topic:	Oracle range partitioning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 06:44:56 CST 2025