OraFAQ Forum: Server Utilities » EXP Error

Home » RDBMS Server » Server Utilities » EXP Error (10.2.0.3 /windows 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

EXP Error [message #288363]

Mon, 17 December 2007 04:26

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

Report message to a moderator

Re: EXP Error [message #288364 is a reply to message #288363]

Mon, 17 December 2007 04:34

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?

Report message to a moderator

Re: EXP Error [message #288365 is a reply to message #288363]

Mon, 17 December 2007 04:35

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

Report message to a moderator

Re: EXP Error [message #288664 is a reply to message #288365]

Tue, 18 December 2007 04:47

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 ...

Report message to a moderator

Re: EXP Error [message #288765 is a reply to message #288664]

Tue, 18 December 2007 11:01

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Thanks for feed back!!!

Report message to a moderator

Previous Topic:	Doubt on import utility
Next Topic:	national language characterset

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 26 14:06:14 CDT 2024