方法一:sqlplus ldquo;用户/密码 as sysdbardquo; sqlplus ldquo;sys/sys as sysdbardquo; 方法二:sqlplus/nolog SQLgt;
首页 → 数据库技术
背景:
阅读新闻
Oracle 11g 修改字符集 为 ZHS16GBK
[日期:2013-01-21]
来源:Linux社区
作者:lvsucceed
[字体:]
方法一:sqlplus “用户/密码 as sysdba” sqlplus “sys/sys as sysdba”
方法二:sqlplus/nolog
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 ZHS16GBK;
ORA-12712: new character set must be a superset of old character set