oracle源端:redhat5.8 + oracle10.2.0.5.0
oracle目标端:centos6.4 + 11.2.0.3.0
导出介质:aix为服务端的nfs介质
导出语句:
[oracle@hpb1 hess]$ expdp xxx/xxx PARALLEL=6 directory=zy_dir dumpfile=BAN_GT_%u.dmp logfile=BAN_GT.log schemas=BAN_GT exclude=statistics
报错:
ORA-31693: Table data object “BAN_GT”.“PB90” failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-39077: unable to subscribe agent ORA-39077: unable to subscribe agent KUPC$A_1_20181016
CAUSE:ORA-600 [QMCXEGETPFXID2] from EXPDP of TABLE with XMLTYPE column and database character set is not UTF8
看一下我的环境:
SQL> SHOW PARAMETER NLS_LANGUAGE;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_language string AMERICAN
SQL> SHOW PARAMETER NLS_TERRITORY;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_territory string AMERICA
SQL> SELECT name, value$ from SYS.PROPS$ WHERE name = 'NLS_CHARACTERSET';
NAME VALUE$
------------------------------ --------------------------------------------------------------------------------
NLS_CHARACTERSET ZHS16GBK
看了一下对象"BAN_GT".“PB90”,也木有SYS.XMLType 数据类型。
解决:
改一下导出语句:
[oracle@hpb1 hess]$ expdp xxx/xxx PARALLEL=6 directory=zy_dir dumpfile=BAN_GT_%u.dmp logfile=BAN_GT.log schemas=BAN_GT exclude=statistics version=10.2.0.5.0
不报错了。