Search This Blog

Sunday, October 19, 2008

EXP-00056 + ORA-00932

The following error message i am getting during export operation in 10gr1 on windows platform after apply the cpu october 2008 patch.

EXP-00056: ORACLE error 932 encountered

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

When i Search on metalink i found below metalink note: 339938.1

The above problem can be fixed to run the following SQL script as SYSDBA user.

SQL> connect / as sysdba

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

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

No comments: