ORACLE imp导入数据报错 ORA-12899

上一篇 / 下一篇 2019-12-10 18:46:32 / 个人分类：oracle

解决方法：

[oracle@OCP imp]$ sqlplus / as sysdba

SQL>SHUTDOWN IMMEDIATE

SQL>STARTUP MOUNT

SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;

SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0;

SQL>ALTER DATABASE OPEN;

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

报字符集不兼容，此时下INTERNAL_USE指令不对字符集超集进行检查：

SQL>ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK;

SQL>SHUTDOWN IMMEDIATE

SQL>STARTUP

TAG: