暂无图片
IMPDP时字符集转换问题
我来答
分享
永远在路上
2022-04-12
IMPDP时字符集转换问题

-bash-4.2$ impdp scott/tiger@pdb1 directory=impdir dumpfile=emp20220412.dmp logfile=emp20220412.log

Import: Release 19.0.0.0.0 - Production on Tue Apr 12 10:46:02 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Master table "SCOTT"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
Warning: possible data loss in character set conversions
Starting "SCOTT"."SYS_IMPORT_FULL_01": scott/********@pdb1 directory=impdir dumpfile=emp20220412.dmp logfile=emp20220412.log
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "SCOTT"."EMP" 8.562 KB 14 rows
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
ORA-39083: Object type REF_CONSTRAINT:"SCOTT"."FK_DEPTNO" failed to create with error:



import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
Warning: possible data loss in character set conversions

源库的字符集是:ZHS16GBK 

目标库的字符集是:AL32UTF8 

如果源库中有中文的话,那么在导入到目标库中的时候就会有数据丢失!

我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
dbtiger

源端和目标端字符集不一致或不相容,就会出现这类似问题。

方法一:
所以,建议将目标端改成和源端一致在导入(可以参考:https://blog.csdn.net/cjfdobzi17256/article/details/100443152)。

方法二:
如果目标端字符集不变。那么可以尝试使用工具端来变更字符集,常用的三方迁移工具有:datax,kettle等。

方法三:
或者改变导出文件格式(txt,csv等),然后使用Oracle自带的sqlldr进行导入。

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏