遇到oracle错误932,OracleEXP-00056: ORACLE error 932 encountered(ORA-00932)

1、问题？

EXP-00056: ORACLE error 932 encountered

ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR

EXP-00056: ORACLE error 932 encountered

ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR

EXP-00000: Export terminated unsuccessfully

2、答案：

Full Export From 10.2.0.1 Aborts With EXP-56 ORA-932 (Inconsistent Datatypes) EXP-0 [ID 339938.1]

Symptoms

A full database export from a Oracle10g database aborts with:

...

. exporting cluster definitions

EXP-00056: ORACLE error 932 encountered

ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR

EXP-00056: ORACLE error 932 encountered

ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR

EXP-00000: Export terminated unsuccessfully

EXP-00000: Export terminated unsuccessfully

Cause

One possible cause (note there might be others):

Script. $ORACLE_HOME/rdbms/admin/catmeta.sql has been run recently.

There are several invalid SYS.KU$_% views in the dictionary:

-- invalid objects:

SET lines 120 pages 2000

COL status FOR a9

COL object_type FOR a20;

COL owner.object FOR a50

SELECT status, object_id, object_type, owner||'.'||object_name "OWNER.OBJECT"

FROM dba_objects

WHERE status != 'VALID' AND object_name NOT LIKE 'BIN$%'

ORDER BY 4,2;

STATUS     OBJECT_ID OBJECT_TYPE     OWNER.OBJECT

--------- ---------- --------------- --------------------------------

INVALID         7105 PACKAGE BODY    SYS.DBMS_METADATA

INVALID         6683 VIEW            SYS.KU$_10_1_COMMENT_VIEW

INVALID         6788 VIEW            SYS.KU$_10_1_IND_STATS_VIEW

INVALID         6778 VIEW            SYS.KU$_10_1_PIND_STATS_VIEW

INVALID         6752 VIEW            SYS.KU$_10_1_PTAB_STATS_VIEW

INVALID         6770 VIEW            SYS.KU$_10_1_SPIND_STATS_VIEW

INVALID         6748 VIEW            SYS.KU$_10_1_TAB_ONLY_STATS_VIEW

... (etc)

A query in SQL*Plus on sys.ku$_xmlschema_view also fails with ORA-932:

SET lines 200 pages 2000

COL url FOR a60 WRA

SELECT url, local, stripped_val

FROM sys.ku$_xmlschema_view;

ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR Solution

For reasons having to do with compatibility, the XDB objects cannot be created by the catproc.sql script. The script. catproc.sql therefore calls the catmeta.sql script, which contains fake object views for XDB objects.

The real object views are defined in the catmetx.sql script. (this script. is invoked by catxdbv.sql which is invoked by catqm.sql).

Solution #1

Run following scripts while connected as SYS user:

> sqlplus /nolog

SQL> connect / as sysdba

SQL> @?/rdbms/admin/catmetx.sql

SQL> @?/rdbms/admin/utlrp.sql

SQL> exit