impdp导入ORA-31693 ORA-38500

今天做导数的时候遇到这么个错误，怎么都导入不了！metlink上查了一下，居然是表结构不一致导致的。

下面是metlink的注释，11.2以后才出现。。

Oracle Server - Enterprise Edition - Version: 11.2.0.3 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Goal

IMPDP is getting error:

ORA-31693: Table data object "SYSADM"."PS_ACAD_CAR_TBL" failed to load/unload and is being skipped due to error:
ORA-38500: Unsupported operation: Oracle XML DB not present

This table is a standard table and does not use XML DB. Why is the XML DB error reported?

 

Solution

You are correct the issue is generated when tables have differences.  Here in an example.

create table u1.t1
(
col1 char(1) not null,
col2 char(1),
constraint pk_t1 primary key (col1) using index
);
insert into t1 values('a','a');
commit;

expdp u1/u1 DUMPFILE=exp