EXP-00056: ORACLE error 932 encountered
in [Oracle]
|
From: Maria on 4 Nov 2005 12:58 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
From: boc on 4 Nov 2005 13:41 Metalink shows a bug caused by differences in XDB schema, check Note:339938.1. Unfortunately, the solution is missing part of the fix :( maybe its rerunning catqm.
From: Maria on 8 Nov 2005 22:10 boc wrote: > Metalink shows a bug caused by differences in XDB schema, check > Note:339938.1. Unfortunately, the solution is missing part of the fix > :( maybe its rerunning catqm. Thank you Actualy I had to reinstall the XDB and run the catqm now the export works fine, I just dont understand one thing I have another server running 10G R2 with no XDB and I have no issues same O/S same oracle version, its odd
|
Pages: 1 Prev: RAC internals - GLOBAL ENQUEUE SERVICES DEADLOCK DETECTED Next: ORA-00600 |