I recently created a 10.2.0.2 database on an Itanium server. I then exported schemas from an 220.127.116.11 database into this database. Not whenever I try to do an export, I get the below error and Export stop unsuccessfully:
Exp-00056-Oracle error 932 encountered
Ora-00932: inconsistent datatypes; expected Blob, Clob got char
I looked at Metalink. It suggested several things:
1. Create the database again with the NLS_LENGTH_SEMANTICS= BYTE (The database was created in byte)
2. Change NLS_LENGTH_SEMANTICS to CHAR. I did this with no effect. However, I did not shut the database
down. I did not see any instructions to do this.
3. Deinstall and Reinstall XDB using Catnoqm.sql and Catqm.sql. This was also done with no effect.
Anyone have any thoughts before I write an SR.