Oracle10g如何修改数据库的字符集？

bitizerg

1. make sure parallel_server = false.

2. shutdown database
   do a full database backup
3.
SQLPLUS> STARTUP MOUNT;
SQLPLUS> ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQLPLUS> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQLPLUS> ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SQLPLUS> ALTER DATABASE OPEN;
SQLPLUS> ALTER DATABASE [NATIONAL] CHARACTER SET INTERNAL_USE [INTERNAL_CONVERT] <new_character_set>;
SQLPLUS> SHUTDOWN IMMEDIATE; -- OR NORMAL
SQLPLUS> STARTUP RESTRICT;

4. shutdown database
   startup db

8i,9i,10g我都试过

zhangfan

楼上的方法有个条件:
原字符集是新字符集的子集