oracle字符集设置错误的补救方法

SQL> conn /as sysdba  
    SQL> shutdown immediate;  
    SQL> startup mount  
    SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;  
    SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;  
    SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;  
    SQL> alter database open;  
    SQL> ALTER DATABASE character set INTERNAL_USE ZHS16GBK;  
    SQL> ALTER DATABASE CHARACTER SET ZHS16GBK;  
    SQL> shutdown immediate;  
    SQL> startup




如果报错ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'

则
alter tablespace UNDOTBS1 add datafile '/oracle/app/oradata/eidc/UNDOTBS1.dbf' size 2000M;

修改字符集前的脚本可能需要重新刷，才能正常显示中文