EXP时发生ORA-00932错误的解决

最新推荐文章于 2024-07-01 10:49:03 发布

daimin1983

最新推荐文章于 2024-07-01 10:49:03 发布

阅读量2.5k

点赞数

分类专栏： ORA 文章标签： character oracle database library user function

本文链接：https://blog.csdn.net/daimin1983/article/details/3855806

版权

ORA 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

EXP时发生ORA-00932错误的解决

[oracle@localhost ~]$ exp rman/rman@CATA file=/opt/cata.dmp owner=rman
Export: Release 10.2.0.1.0 - Production on Sat Jan 31 21:22:06 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user RMAN
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user RMAN
About to export RMAN's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 932 encountered
ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR
EXP-00000: Export terminated unsuccessfully

要解决这个错误，需要运行2个脚本：
SQL> @/opt/oracle/product/10.2.0/rdbms/admin/catmetx.sql

SQL> @/opt/oracle/product/10.2.0/rdbms/admin/utlrp.sql