exp导出的问题
原创
©著作权归作者所有:来自51CTO博客作者帅小伙的原创作品,请联系作者获取转载授权,否则将追究法律责任
昨天payment从测试库到另外一个测试库进行迁移,导出时,出现如下故障:
[oracle@oracle02 ~]$ exp userid=test/test file=test.dmp buffer=1024 owner=test
Export: Release 10.2.0.1.0 - Production on Tue Nov 28 15:09:42 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export specified users ...
.EXP-00056: ORACLE error 932 encountered
ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR
EXP-00000: Export terminated unsuccessfully
原因:数据字典中有存在一些无效KU$_视图;
SQL> select * from sys.ku$_xmlschema_view;
select * from sys.ku$_xmlschema_view
*
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR
解决办法:
1.执行对象视图定义脚本 $ORACLE_HOME/rdbms/admin/catmetx.sql
SQL> @?/rdbms/admin/catmetx.sql
Package altered.
Index altered.
View created.
Grant succeeded.
View created.
Grant succeeded.
Procedure created.
System altered.
System altered.
System altered.
PL/SQL procedure successfully completed.
Procedure dropped.
2.执行重新编译无效对象脚本 $ORACLE_HOME/rdbms/admin/utlrp.sql
SQL> @?/rdbms/admin/utlrp.sql
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
验证一下程序
SQL> select * from ku$_xmlschema_view;
V V OWNER_NUM OWNER_NAME URL
- - ---------- ------------------------------ ---------------
1 0 46 MDSYS [url]http://www.opengis.net/gml/geometry.xsd[/url]
1 0 46 MDSYS [url]http://www.w3.org/1999/xlink/xlinks.xsd[/url]
1 0 46 MDSYS [url]http://www.opengis.net/gml/feature.xsd[/url]
重新执行导出程序exp,一些正常。
![](https://ucenter.51cto.com/images/noavatar_middle.gif)
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
PowerDesigner用Connection profile导出Mysql数据字典常见问题
PowerDesigner 导出数据字典时,连接数据库会提示错误,本文针对自己遇到的问题,总结处理方法。
java mysql PowerDesigner -
imp,exp导入导出
在服务器端使用。2、expdp和impdp是服务器端
表空间 数据库 数据