Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Getting Prob In Exporting File.....

135 views
Skip to first unread message

DHILEN JOGI

unread,
Jan 13, 2012, 6:28:49 AM1/13/12
to


hi every body ,
i do not know why i am face this problem:
when i m trying to import file in perticular schema i got list of
errors like belllow


illegal lob length marker 48129
bytesread = 00000000000
TABLE = CONVERSION
IMP-00098: INTERNAL ERROR: impgst2
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:

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-00009: abnormal end of export file
Import terminated successfully with warnings.

.
so plz if any one know regarding this problem inform immediately
thnx in advance
Dhilen Jogi..

marco P.

unread,
Jan 13, 2012, 9:18:22 AM1/13/12
to
Hi,

try the import using show=yes. If the same error is reported again,
then this mean that the file is corrupted.

see metalink note ID 578616.1

Mark D Powell

unread,
Jan 13, 2012, 12:23:37 PM1/13/12
to
Your post should really include the Oracle version and which import utility is being used to perform the import and well as what version of Oracle the export dmp file was created on.

If the dmp file was FTP'd between servers you may wish to verify that a binary FTP was used as an ASCII FTP may have resulted in content conversion of NL to CR + NL or the opposite depending on the types of platforms the export and import are being performed on.

HTH -- Mark D Powell --
0 new messages