Home » RDBMS Server » Server Administration » How to change the character set in oracle (linux oracle)
How to change the character set in oracle [message #340313] Tue, 12 August 2008 05:22 Go to next message
shiju_t_v
Messages: 56
Registered: May 2007
Location: kannur,kerala
Member
How to change the character set in oracle
Re: How to change the character set in oracle [message #340315 is a reply to message #340313] Tue, 12 August 2008 05:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Recreate the database.

Regards
Michel
Re: How to change the character set in oracle [message #341133 is a reply to message #340313] Sat, 16 August 2008 23:54 Go to previous messageGo to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
it may work for u......
http://sadatdba.blogspot.com/2008/07/changing-character-set-in-oracle.html

[Updated on: Sat, 16 August 2008 23:55]

Report message to a moderator

Re: How to change the character set in oracle [message #341143 is a reply to message #341133] Sun, 17 August 2008 00:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If direct conversion is possible it is much easier to use standard CSALTER script:
Migrating a Character Set Using the CSALTER Script

Regards
Michel
Re: How to change the character set in oracle [message #342764 is a reply to message #340313] Sun, 24 August 2008 23:44 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Don't use ALTER DATABASE statement to change your database characterset. If you do so you bring trouble in your database.
Previous Topic: how do i drop tablespace that there datafiles has been dropped
Next Topic: checkpoint/SCN
Goto Forum:
  


Current Time: Sun Dec 11 03:57:24 CST 2016

Total time taken to generate the page: 0.13493 seconds