Home » RDBMS Server » Server Administration » Character set conversion
Character set conversion [message #303313] Thu, 28 February 2008 20:13 Go to next message
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
Re: Character set conversion [message #303314 is a reply to message #303313] Thu, 28 February 2008 20:45 Go to previous messageGo to next message
BlackSwan
Messages: 25042
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
Re: Character set conversion [message #303359 is a reply to message #303313] Fri, 29 February 2008 00:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is only one way: export/create a new database/import

Regards
Michel
Re: Character set conversion [message #303460 is a reply to message #303359] Fri, 29 February 2008 07:35 Go to previous messageGo to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
Can't i use CSALTER to convert?
-GK
Re: Character set conversion [message #303463 is a reply to message #303460] Fri, 29 February 2008 07:51 Go to previous message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Wed Dec 07 05:15:40 CST 2016

Total time taken to generate the page: 0.08936 seconds