OraFAQ Forum: Server Administration » How to change the character set in oracle

Home » RDBMS Server » Server Administration » How to change the character set in oracle (linux oracle)

Tue, 12 August 2008 05:22

shiju_t_v
Messages: 56
Registered: May 2007
Location: kannur,kerala

Member

How to change the character set in oracle

Tue, 12 August 2008 05:27

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

Senior Member
Account Moderator

Recreate the database.

Regards
Michel

Sat, 16 August 2008 23:54

tanmoy1048
Messages: 133
Registered: June 2007

Senior Member

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

Sun, 17 August 2008 00:54

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

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

Sun, 24 August 2008 23:44

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: Sat Jan 11 22:10:00 CST 2025