修改oracle9i数据库字符集的方法

shutdown immediate;
STARTUP MOUNT;
ALTER SESSION SET SQL_TRACE=TRUE;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
SQL> ALTER DATABASE character set INTERNAL_USE zhs16gbk;
SQL> select value from nls_database_parameters where parameter='NLS_CHARACTERSET';
ALTER SESSION SET SQL_TRACE=FALSE;