Importing 9.2 to 10.2
567981Mar 23 2007 — edited Mar 23 2007Hi 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