Home » RDBMS Server » Server Utilities » import dmp 10G error (10.2.0.1.0/win XP)
icon5.gif  import dmp 10G error [message #289148] Wed, 19 December 2007 20:14 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: import dmp 10G error [message #289198 is a reply to message #289148] Thu, 20 December 2007 02:10 Go to previous messageGo to next message
milano
Messages: 3
Registered: December 2007
Junior Member
in export file log said exporting succesfull without error.
Re: import dmp 10G error [message #289199 is a reply to message #289198] Thu, 20 December 2007 02:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Good point but what about the 3 ones I mentioned?

Regards
Michel
Re: import dmp 10G error [message #289698 is a reply to message #289148] Tue, 25 December 2007 10:29 Go to previous messageGo to next message
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
Re: import dmp 10G error [message #289702 is a reply to message #289698] Tue, 25 December 2007 11:19 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: character set mismatching in import
Next Topic: Can we have multiple delimiters in one control file?
Goto Forum:
  


Current Time: Sat Dec 10 18:18:50 CST 2016

Total time taken to generate the page: 0.07457 seconds