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).
Run following scripts while connected as SYS user:
SQL> connect / as sysdba