EXP-00056: ORACLE error 932 encountered

Giganews Newsgroups
Subject: EXP-00056: ORACLE error 932 encountered
Posted by:  Maria (evorad…@yahoo.ca)
Date: 4 Nov 2005

Hello

I have an oracle database 10.2.0.1.0 running on Solaris 5.8 which I
imported the data from a different version 10.1.0.4.0, the Import was
done fromuser=test touser=test, after I tried to export the same data
out and I keep getting these error messages
EXP-00056: ORACLE error 932 encountered
ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR
EXP-00000: Export terminated unsuccessfully

This is the export command

exp test/test file=/backup/oracle/test.dmp statistics=none log=test.log

But if I export a table by table there are no issues, what is wrong?
Thank you

Replies