OraFAQ Forum: Server Administration » Character set conversion

Home » RDBMS Server » Server Administration » Character set conversion

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

Character set conversion [message #303313]

Thu, 28 February 2008 20:13

caprikar
Messages: 226
Registered: March 2007

Senior Member

Hi,
I need to convert my database (version 10.1.0.5 ) character set from WE8ISO8859P1 to UTF8, the OS is SUN 5.8. What is the best method to achieve this? Did anyone had any problem doing this conversion?
Thanks,
GK

Report message to a moderator

Re: Character set conversion [message #303314 is a reply to message #303313]

Thu, 28 February 2008 20:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>What is the best method to achieve this?
By Reading The Fine Manual below & following its guidelines

http://download.oracle.com/docs/cd/B14117_01/server.101/b10749/toc.htm

Report message to a moderator

Re: Character set conversion [message #303359 is a reply to message #303313]

Fri, 29 February 2008 00:26

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

Senior Member
Account Moderator

There is only one way: export/create a new database/import

Regards
Michel

Report message to a moderator

Re: Character set conversion [message #303460 is a reply to message #303359]

Fri, 29 February 2008 07:35

caprikar
Messages: 226
Registered: March 2007

Senior Member

Can't i use CSALTER to convert?
-GK

Report message to a moderator

Re: Character set conversion [message #303463 is a reply to message #303460]

Fri, 29 February 2008 07:51

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

Senior Member
Account Moderator

Migrating a Character Set Using the CSALTER Script

Quote:

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.

=> No unless you only used US7ASCII data.

Regards
Michel

[Updated on: Fri, 29 February 2008 07:52]

Report message to a moderator

Previous Topic:	ORA-01031: insufficient privileges
Next Topic:	National Character Set

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 23:43:02 CST 2024