Oracle Dump Import Error IMP-00085

Asked By 0 points N/A Posted on -
qa-featured

Hi,

I am trying to import an Oracle 10g R2 export dump into an Oracle 11g database. However, I am encountering the error mentioned below. How do I solve this issue? Thanks in advance.

IMP-00085: multiple input files specified for unbounded export file
IMP-00000: Import terminated unsuccessfully

SHARE
Best Answer by amjadawan42
Best Answer
Best Answer
Answered By 0 points N/A #124574

Oracle Dump Import Error IMP-00085

qa-featured

 

You have not mentioned your OS details and 11g version you are using, normally this error occurs due to issues with number of dump files. You should try following solutions as your posted information is incomplete.

i) Try IMPDP & EXPDP instead of IMP/EXP.

ii) You should check the character set of both of your systems (source & destination)

iii) Review your import/export queries and check any missing or incomplete parameter.

iv) You should verify FILE parameter while importing with header information in your exported file.

It's still not solved than attach a screen shot of the error you are facing.

Thanks

 

Answered By 0 points N/A #124577

Oracle Dump Import Error IMP-00085

qa-featured

Hello Hj,

Yes the error "IMP-00085: multiple input files specified for unbounded export file" comes because you have specified two or more file names for the FILE parameters while you were importing, but the export operation could only create one file mentioned in the header file. Recheck your FILESIZE parameter, it should be non zero for the multiple file names.

This will solve your problem.

Thanks 

 

Login/Register to Answer

Related Questions