今天需要对一个数据库中的用户导出. 而且由于客户的要求只能使用exp工具操作.

结果遇到了下述错误.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in UTF8 character set and AL16UTF16 NCHAR character set
......

EXP-00056: ORACLE error 932 encountered
ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR
EXP-00000: Export terminated unsuccessfully.

于是使用10046和errorstack 来设置trace.

alter system set events '10046 trace name context forever,level 12';

alter system set events '932 trace name errorstack';

再次执行exp, 出现错误后,检查trace 文件,发现错误和

SELECT URL, LOCAL, STRIPPED_VAL      FROM SYS.KU$_XMLSCHEMA_VIEW      WHERE OWNER_NAME = :OWNER

在sqlplus中执行SELECT URL, LOCAL, STRIPPED_VAL      FROM SYS.KU$_XMLSCHEMA_VIEW返回同样的错误.

查阅metalink之后确定与XDB有关,由于数据库没有使用XDB,所以参考Doc ID 1292089.1,和1375280.1删除了XDB

@?/rdbms/admin/catnoqm.sql
@?/rdbms/admin/catmeta.sql
drop view ALL_XML_SCHEMAS;
drop view ALL_XML_SCHEMAS2;
@?/rdbms/admin/utlrp.sql

检查sys中无非法对象,

select comp_name,comp_id, status, version from dba_registry;
检查所有组件状态正常.

再次执行exp,正常导出.

今天需要对一个数据库中的用户导出. 而且由于客户的要求只能使用exp工具操作.结果遇到了下述错误.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsExport d EXP -00056: 遇到 ORA CLE 错误 932 ORA -00 932 : 数据类型不一致: 应为 BLOB, CLOB, 但却获得 CHAR EXP -00000: 导出 终止 失败 解决方法：... 今天执行 Ora cle 的sql 查询语句的 时 候，出现了一条以前没有 遇到 过的 错误 ： ORA -00 932 : 数据类型不一致: 应为 -, 但却获得 CLOB 经过百度和自己和实际情况改好了。 错误 前的sql语句： select m.m_id,m.m_title,m.m_content,wm_concat(a_oldName) a_oldName from t_me... SELECT SUM(debitquantity) AS "debitquantity", SUM(debitamount) AS "debitamount", SUM(localdebitamount) AS "localdebitamount", SUM(cred... wangjnwang: SELECT A.[c1],B.[c1],C.[c1],D.[c1],E.[c1],A.[c1]+B.[c1]+C.[c1],D.[c1]+E.[c1] FROM [t1] A,[t1] B,[t1] C,[t1] D,[t1] E WHERE A.[c1]<B.[c1]AND B.[c1]<C.[c1] AND D.[c1]<E.[c1] AND (A.[c1]+B.[c1]+C.[c1])=2*(D.[c1]+E.[c1])