ORA-31693 ORA-38500: Unsupported operation: Oracle XML DB not present在使用expdp/impdp导入导出时,碰到如下问题:ORA-31693: Table data object "IMS"."ETT_CNTNT" failed to load/unload and is being skipped due to error:
ORA-38500: Unsupported operation: Oracle XML DB not present
. . imported "IMS"."INBOUND" 710.0 KB 742 rows
. . imported "IMS"."OUTBOUND" 524.4 KB 750 rows
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "JOB02"."SYS_IMPORT_TABLE_02" completed with 1 error(s) at 20:12:00请教大家该如何解决?环境从一个生产库导出,并导入到另一个生产库
两边数据库的环境相同
SunOS zzz 5.10 Generic_144488-01 sun4u sparc SUNW,SPARC-Enterprise
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
ORA-38500: Unsupported operation: Oracle XML DB not present
. . imported "IMS"."INBOUND" 710.0 KB 742 rows
. . imported "IMS"."OUTBOUND" 524.4 KB 750 rows
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "JOB02"."SYS_IMPORT_TABLE_02" completed with 1 error(s) at 20:12:00请教大家该如何解决?环境从一个生产库导出,并导入到另一个生产库
两边数据库的环境相同
SunOS zzz 5.10 Generic_144488-01 sun4u sparc SUNW,SPARC-Enterprise
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
ORA-31693 ORA-38500: Unsupported operation: Oracle XML DB not present
不支持此操作,oracle XML 数据库不存在
On source server:
SQL> show parameter instance_nameNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string ODBA
SQL> show parameter db_nameNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string ODBA
SQL> select comp_name "Component" from dba_registry;Component
---------------------------------------------
Oracle Database Catalog Views
Oracle Database Packages and Types
Oracle Text############################################################################
On target server:
SQL> show parameter instance_nameNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string ODBB
SQL> show parameter db_nameNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string ODBB
SQL> col Component format a45
SQL> select comp_name "Component" from dba_registry;Component
---------------------------------------------
Oracle Database Catalog Views
Oracle Database Packages and Types