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-01555的报错,大家有过解决经验和体会的,都来说说吧
- 求助~~~如何保留归档日志
- oracle 分页查询
- 数据库中数值的转化
- linux下proC编译问题?
- 急! 急! 急!一个比较复杂的统计查询!
- 请高手解决启动问题,分不够再加!!!!!!!!!!!
- 刚安装的oracle personal 8.1.7用sqlplus咋连接不了,服务都启动了。系统是window2000professional
- Unique字段的值想通过c#来修改,怎么实现??
- 如何通过SQL语句得到类似于Listener.log文件中的信息 , 包括登入用户名, 登入program ,ip , pc机器名 , 登入时间 ,所做的动作(sql语句).
- SELECT语句求助
- sys.obj$里面的东西可以直接删吗?
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