EXP-00056: ORACLE error 932 encountered

From: Maria <evoradba_at_yahoo.ca>
Date: 4 Nov 2005 09:58:19 -0800
Message-ID: <1131127099.687485.264940@g14g2000cwa.googlegroups.com>

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 Received on Fri Nov 04 2005 - 11:58:19 CST