文章摘要: imp报错IMP-00019: row rejected due to ORACLE error 12899
时间:2016-05-18 22:09来源:未知 作者:admin 点击: 次
文章TAG:
到生产库上用
select userenv('language') from dual;
查看到是ZHS16GBK,而本机库是utf-8用一下命令修改本机库字符集
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 INTERNAL_USE ZHS16GBK;
SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP;
再用上面的命令查一下本机的字符集,如果没有问题,可以重新导入。
|