更改oracle字符集 error: ora-12712 解决方法

发布时间：2020-12-12 15:47:19 所属栏目：百科来源：网络整理

导读：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

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 NLS_CHARACTERSET from nls_database_parameters;

转自：http://blog.sina.com.cn/s/blog_6b1f190e0100qg42.html

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!