Changing Character set of database....

To change Character set of database either we have several methods.

1) If you have empty database then drop and recreate the database with new character set.
2) Go with following steps.

> SHUT IMMEDIATE

--Take full db backup .

> STARTUP MOUNT

> ALTER SYSTEM ENABLE RESTRICTED SESSION;

> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

>ALTER SYSTEM SET AQ_TM_PROCESSES=0;

>ALTER DATABASAE OPEN;

>ALTER DATABASE CHARACTER SET INTERNAL_USE US7ASCII  ;