ITPub博客

首页 > 数据库 > Oracle > oracle修改字符集

oracle修改字符集

原创 Oracle 作者:huangdazhu 时间:2014-03-26 16:39:58 0 删除 编辑

server端字符集修改 
将数据库启动到RESTRICTED模式下做字符集更改:
SQL> conn /as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area  236000356 bytes
Fixed Size                   451684 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
System altered
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
System altered.
SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;
System altered.
SQL> alter database open;
Database altered.
SQL> ALTER DATABASE CHARACTER SET ZHS16GBK;
ALTER DATABASE CHARACTER SET ZHS16GBK
*
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set

SQL> ALTER DATABASE character set INTERNAL_USE ZHS16GBK; 
最后再重启下数据库即可

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28869493/viewspace-1130065/,如需转载,请注明出处,否则将追究法律责任。

下一篇: tomcat 配置ssl访问
请登录后发表评论 登录
全部评论

注册时间:2013-05-08

  • 博文量
    185
  • 访问量
    408019