日期:2014-05-16  浏览次数:20403 次

imp命令 将dbp数据导入数据库 nls_character不一致

Export file created by EXPORT:V10.02.01 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
export client uses ZHS16GBK character set (possible charset conversion)
. importing TEST's objects into TEST
. importing TEST's objects into TEST

IMP-00019: row rejected due to ORACLE error 12899

这个错误是因为原来的和目的数据库中的nls_character 不一样,

select userenv('language') from dual;
select * from v$nls_parameter;
可以查看nls_character。