Home » RDBMS Server » Server Utilities » EXP Error (10.2.0.3 /windows 2003)
EXP Error [message #288363] Mon, 17 December 2007 04:26 Go to next message
saagar
Messages: 79
Registered: December 2007
Member
Dear all
i am getting this error
as i am doing exp on the database
EXP-00056: ORACLE error 932 encountered
ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR
EXP-00056: ORACLE error 932 encountered
ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR
EXP-00000: Export terminated unsuccessfully

please advice
Re: EXP Error [message #288364 is a reply to message #288363] Mon, 17 December 2007 04:34 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

This is happened Due to Oracle Bug 5566304 and Bug 4886376.

Did you create your database by nls_length_semantics with CHAR?
Re: EXP Error [message #288365 is a reply to message #288363] Mon, 17 December 2007 04:35 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I got metalink address according to your problem.

https://metalink.oracle.com/metalink/plsql/f?p=130:14:4839444817605434036::::p14_database_id,p14_docid,p14_show_header,p14_show_help, p14_black_frame,p14_font:NOT,396454.1,1,1,1,helvetica
icon14.gif  Re: EXP Error [message #288664 is a reply to message #288365] Tue, 18 December 2007 04:47 Go to previous messageGo to next message
saagar
Messages: 79
Registered: December 2007
Member
hey all
i gotta a solution for this problem
run the scripts
catmetx.sql and utlrp.sal

and then again ...
do the export
it will work ...
Re: EXP Error [message #288765 is a reply to message #288664] Tue, 18 December 2007 11:01 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Thanks for feed back!!!
Previous Topic: Doubt on import utility
Next Topic: national language characterset
Goto Forum:
  


Current Time: Sun Dec 04 04:41:38 CST 2016

Total time taken to generate the page: 0.14457 seconds