expdp：ORA-31693 ORA-29913 ORA-29275

expdp报错：

ORA-31693: Table data object "LZL"."TAB1" failed to load/unload and is being skipped due to error:

ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout

ORA-29275: partial multibyte character

源库环境是AIX6.1，客户端是RHEL4.7

我的expdp 使用的dblink导出了多个表，但是只有这张表导不出来 

看下这个表有没有大字段（long不能通过dblink的方式导出）

 很正常的一张表

 

再写个expdp单独导这张表

expdp \'/ as sysdba\' cluster=N  NETWORK_LINK=dba_lzl_lk directory=nzdir   dumpfile=lzl_tab1.dmp logfile=lzl_tab1.log  COMPRESSION=ALL   estimate=statistics  REUSE_DUMPFILES=y tables=lzl.tab1

同样报错。

 

找了一台aix的机器，客户端就是AIX6.1。执行expdp成功。

看来异构的数据泵还是有问题

 

尝试用impdp导入到rhel环境的数据库中

dbmonitor:/nzdmp>impdp \'/ as sysdba\' cluster=N  NETWORK_LINK=lzl_dblink directory=nzdir  tables=lzl.tab1  table_exists_action=replace

Import: Release 11.2.0.4.0 - Production on Mon Nov 12 11:38:41 2018

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"."SYS_IMPORT_TABLE_01":  "/******** AS SYSDBA" cluster=N NETWORK_LINK=lzl_dblink directory=nzdir tables=lzl.tab1  table_exists_action=replace 
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 24 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-31693: Table data object "UCR_PARAM"."SEC_ORGANIZE" failed to load/unload and is being skipped due to error:
ORA-29275: partial multibyte character

不落地导入该表，还是报错

 

不用数据泵导了，直接用exp导出