| EXP-00056: ORACLE error 932 encountered [message #145532] |
Thu, 03 November 2005 13:10  |
evoradba
Messages: 144
Registered: April 2005
Location: Canada
|
Senior Member |
|
|
Hello
I have an oracle database 10.2.0.1.0 running on Solaris 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
|
|
|
|
|
|
| Re: EXP-00056: ORACLE error 932 encountered [message #169247 is a reply to message #145532] |
Tue, 25 April 2006 22:25  |
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
|
Senior Member |
|
|
What's version of "exp" when you dump the data from 10.1.0.4.0?
What's version of "imp" when you dump the data from 10.2.0.1.0?
My suggestion is that using both exp and imp in version 10.1.0.4.0.
Alex zeng|Skype me: hans9zeng
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
