修改字符遇到ORA-12712

SQL> alter database character set internal_convert WE8ISO8859P1;
alter database character set internal_convert WE8ISO8859P1
*
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set

提示新字符必须是老字符的超集。

查看目标库字符。
select tab1.aa||'_'||tab2.bb||'.'||tab3.cc from
(select VALUE$ aa from sys.props$ where name='NLS_LANGUAGE')tab1,
(select VALUE$ bb from sys.props$ where name='NLS_ISO_CURRENCY')tab2,
(select VALUE$ cc from sys.props$ where name='NLS_CHARACTERSET')tab3;

AMERICAN_AMERICA.AL32UTF8

进行强制修改。

SQL> alter database character set internal_useWE8ISO8859P1;

Database altered.