本文介绍了解决ORACLE数据库在进行数据导入导出时遇到的字符集不一致导致的错误IMP-00019。通过查询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。
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。
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
