Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Importing 9.2 to 10.2

567981Mar 23 2007 — edited Mar 23 2007
Hi All,

I'm trying to import a full dump from 9.2 to 10.2 for days now and cannot figure out what the problem is. 10.2 is on a different server but also windows 2003 SP2.

NLS_LANG of both machines are the same for client and server:
AMERICAN_AMERICA.WE8ISO8859P1
UFAT is also same on the server.

Every time i try to import it fail after a while, tried to export again with diffeent files and splitting up files but getting the same error over and over.:

This is the error:

. . importing table "HOLDSUBLEDGER"
illegal lob length marker 49664
bytesread = 00000000000
TABLE = HOLDSUBLEDGER
IMP-00098: INTERNAL ERROR: impgst2
IMP-00018: partial import of previous table completed: 181470 rows imported
IMP-00008: unrecognized statement in the export file:

IMP-00008: unrecognized statement in the export file:

IMP-00008: unrecognized statement in the export file:
f
IMP-00008: unrecognized statement in the export file:
f
IMP-00008: unrecognized statement in the export file:

IMP-00008: unrecognized statement in the export file:

IMP-00008: unrecognized statement in the export file:

IMP-00008: unrecognized statement in the export file:

IMP-00008: unrecognized statement in the export file:
S+_5
IMP-00008: unrecognized statement in the export file:

I get a lot of IMP-00008:

When it goes trough it goes fine for a while and tha again the import stops and end

IMP-00009: abnormal end of export file
IMP-00018: partial import of previous table completed: 5084344 rows imported

Thanx for answering
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 20 2007
Added on Mar 23 2007
1 comment
368 views