Getting Prob In Exporting File.....

#1

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:

#2

On Jan 13, 12:28*pm, DHILEN JOGI <kanoj... (AT) gmail (DOT) com> wrote:

Quote:

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..

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

#3

Your post should really include the Oracle version and which import utilityis being used to perform the import and well as what version of Oracle theexport 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 ofNL to CR + NL or the opposite depending on the types of platforms the export and import are being performed on.

HTH -- Mark D Powell --

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Getting Prob In Exporting File.....

comp.databases.oracle.server comp.databases.oracle.server

Getting Prob In Exporting File..... - 01-13-2012 , 05:28 AM

Re: Getting Prob In Exporting File..... - 01-13-2012 , 08:18 AM

Re: Getting Prob In Exporting File..... - 01-13-2012 , 11:23 AM