Tag: 11g datapump got ORA-38500

从10.2.0.5的库导入一张表的增量数据到11.2.0.3 impdp报出如下错误,对比两边表结构一致,tablespace有剩余空间 报错如下:

[oracle@localhost ~]$ impdp  \'\/ as sysdba \'    directory=pump   dumpfile=so.dmp TABLE_EXISTS_ACTION=append

Import: Release - Production on Thu Feb 23 09:44:49 2012

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

Connected to: Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01":  "/******** AS SYSDBA" directory=pump dumpfile=so.dmp TABLE_EXISTS_ACTION=append
Processing object type TABLE_EXPORT/TABLE/TABLE
Table "USER_DATA2"."SO" exists. Data will be appended to existing table but all dependent metadata will be skipped due to table_exists_action of append
ORA-38500: Unsupported operation: Oracle XML DB not present


Data Pump Import Fails With[……]

Read more