-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
如果源库中有中文的话,那么在导入到目标库中的时候就会有数据丢失!
墨值悬赏

评论
