Oracle Dump Import Error IMP-00085

Asked By hj2011 0 points N/A Posted on - 09/17/2011

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

• Status: Open
• Question Views: 5461
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Oracle Database

Best Answer by amjadawan42

Go To Solution

Best Answer

Best Answer

Answered By amjadawan42 0 points N/A #124574

Oracle Dump Import Error IMP-00085

 

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

 

About amjadawan42

Questions
0

Answers
1

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 10/17/2011
• Question Category: Oracle Database

Answered By BrownAnna 5 points N/A #124577

Oracle Dump Import Error IMP-00085

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 

 

About BrownAnna

Questions
3

Answers
102

Best Answers
44

• Vote Up 0 Vote Down

• Posted on - 12/06/2012
• Question Category: Oracle Database