博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

如何更改oracle字符集

Posted on 2011-08-02 15:58  徐正柱-  阅读(297)  评论(0编辑  收藏  举报
sqlplus /nolog
conn /as sysdba
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;
set linesize 120;
alter database character set zhs16gbk;


RROR at line 1:

  ORA-12712: new character set must be a superset of old character set


ALTER DATABASE character set INTERNAL_USE zhs16gbk;

ALTER SESSION SET SQL_TRACE=FALSE;

shutdown immediate;

STARTUP

 

select userenv('language') from dual;