Knowledge Base : Glossary : Suggest a Question
Search The Knowledge Base
Browse The Knowledge Base
Knowledge Base : HQ : Oracle

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

Error While Exp utility for DB backup

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

Afterwards, re-run the export.

Related Articles
There are no related articles

Viewer Comments Add Comment
No viewers have posted comments

Powered By AutoKB