oracle12c impdp数据泵导入报错字符集不一致

环境：

源

   oracle 12.2.0.1 rac

目标

  oracle 12.2.0.1  rac

问题

数据导入报错，信息如下：

  Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Master table "SYS""SYS IMPORT SCHEMA 02" successfully loaded/unloaded
import done in AL32UTF8 character set and UTF8 NCHAR character set
export done in AL32UTF8 character set and AL16UTF16 NCHAR character set
Warning: possible data loss in character set conversions

1、查看源端字符集：

PARAMETER		       VALUE
------------------------------ ------------------------------
NLS_NCHAR_CHARACTERSET	       AL16UTF16
NLS_CHARACTERSET	       AL32UTF8

2、目标端字符集

PARAMETER		       VALUE
------------------------------ ------------------------------
NLS_NCHAR_CHARACTERSET	       AL32UTF8
NLS_CHARACTERSET	       AL32UTF8

对比发现源端和目标端的字符集不一致，这个应该辛苦创建的时候指定national langauge为AL32UTF8

3、更改字符集

更改目标端字符集之后，查看目标端

4、查看更改结果

PARAMETER		       VALUE
------------------------------ ------------------------------
NLS_NCHAR_CHARACTERSET	       AL16UTF16
NLS_CHARACTERSET	       AL32UTF8

5、重新导入数据

依旧报错，信息如下

ORA-31693:Table data object "CAVD"."TS ROLE" failed to load/unload and is being skipped 
dueto error:0RA-02354:error in exporting/importing data
0RA-24329:invalid character set identifier
immported"DSs""CP TEMPI ATEU5.968 KB5 rowsmported "CEDET BAOXIN”"渠道配件价格 20230327"9.148 KB4 rows
ORA-31693: Table data object "LIYINGBO"."CX HGZ FRST DATE" failed to load/unload and is being skipped due to 
error:ORA-02354: error in exporting/importing data
ORA-24329: invalid character set identifier
imported "CVDE PROCESS""TB WORKING LOG0KBorows
imported"CEDET BAOXIN"11.81 KB355 rows"T ZPP CCS3imported"CEDET BAOXIN".
"渠道配件价格 20230607"擞暗鑫胺哎埃比爱 30 KB11 rows
0RA-31693: Table data object "LIYINGB0"."ETL CAR INF0 FROM DIM" failed to load/unload and is being skipped due to 
error:0RA-02354:error in exporting/importing dataO
RA-24329: invalid character set identifier
imported"CATARC DW""T GGOX ZBZL"1551 MB42570 rows
0RA-31693: Table data object "DSs","CITY JW EXTEND" failed to load/unload and is being skipped due to 
error:0RA-02354:error in exporting/importing data
0RA-24329:invalid character set identifier
0RA-31693:Table data object "Dss""SYCZCL CITY COPYu failed to load/unload andis being skipped due to 
error:0RA-02354:error in exporting/importing data
0RA-24329:invalid character set identifier
imported "CATARC DW."T IACI F SALE FINAL CAR":"T IACI F SALEFINALCAR2012"29.85rows

这个字符集已经更改了，为啥还是报字符集的问题呢

6、细颗粒度查询一下字符集

源端

AL16UTF16	NCHAR
AL16UTF16	NCLOB
AL16UTF16	NVARCHAR2
AL32UTF8	CHAR
AL32UTF8	CLOB
AL32UTF8	LONG
AL32UTF8	VARCHAR2

目标端

AL16UTF16	NCHAR
AL16UTF16	NCLOB
AL16UTF16	NVARCHAR2
AL32UTF8	CHAR
AL32UTF8	CLOB
AL32UTF8	LONG
AL32UTF8	VARCHAR2
UTF8	NCHAR
UTF8	NCLOB
UTF8	NVARCHAR2

发现目标端还是有问题，调整national characterset

7、再次调整字符集

alter database national character set INTERNAL_USE AL16UTF16;

再次查询目标端

AL16UTF16	NCHAR
AL16UTF16	NCLOB
AL16UTF16	NVARCHAR2
AL32UTF8	CHAR
AL32UTF8	CLOB
AL32UTF8	LONG
AL32UTF8	VARCHAR2

8、重新导入

发现跟源端一样了，重新impdp导入数据，无异常报错；