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

前端之家收集整理的这篇文章主要介绍了更改oracle字符集 error: ora-12712 解决方法前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
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

原文链接:https://www.f2er.com/oracle/211976.html

猜你在找的Oracle相关文章