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

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

&noracle账号bsp;

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 

  www.2cto.com  

如果报错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; 

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