OraFAQ Forum: Server Utilities » import dmp 10G error

Home » RDBMS Server » Server Utilities » import dmp 10G error (10.2.0.1.0/win XP)

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

import dmp 10G error [message #289148]

Wed, 19 December 2007 20:14

milano
Messages: 3
Registered: December 2007

Junior Member

I import a dmp file use imp in oralce 10G and receive alert

illegal lob length marker 49408
bytesread = 00000000000
TABLE = BTV
IMP-00098: INTERNAL ERROR: impgst2
IMP-00008: unrecognized statement in the export file:

IMP-00008: unrecognized statement in the export file:

Can you help me to fix this?

[Updated on: Wed, 19 December 2007 20:15]

Report message to a moderator

Re: import dmp 10G error [message #289170 is a reply to message #289148]

Wed, 19 December 2007 23:27

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Make sure you transfer your dump file in binary mode.
Make sur the file was not corrupted.
Make sure you use a dump file that was exported by a exp of version less or equal to the imp program.

Regards
Michel

Report message to a moderator

Re: import dmp 10G error [message #289198 is a reply to message #289148]

Thu, 20 December 2007 02:10

milano
Messages: 3
Registered: December 2007

Junior Member

in export file log said exporting succesfull without error.

Report message to a moderator

Re: import dmp 10G error [message #289199 is a reply to message #289198]

Thu, 20 December 2007 02:25

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Good point but what about the 3 ones I mentioned?

Regards
Michel

Report message to a moderator

Re: import dmp 10G error [message #289698 is a reply to message #289148]

Tue, 25 December 2007 10:29

milano
Messages: 3
Registered: December 2007

Junior Member

Thanks michel. I did i t by command imp. but when I use import from oracle enterprise manager it alerts
Errors: ORA-39006: internal error Exception : ORA-39006: internal error ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79 ORA-06512: at "SYS.DBMS_DATAPUMP", line 2926 ORA-06512: at "SYS.DBMS_DATAPUMP", line 3162 ORA-06512: at line 2

what I have to do in this case? Please show me the way to fix it.
Thanks again

Report message to a moderator

Re: import dmp 10G error [message #289702 is a reply to message #289698]

Tue, 25 December 2007 11:19

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Please show me the way to fix it.

First you have to answer the 3 questions I posted.

Regards
Michel

Report message to a moderator

Previous Topic:	character set mismatching in import
Next Topic:	Can we have multiple delimiters in one control file?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 23:12:40 CST 2024