My Oracle Support Banner

IMP-00085 (multiple Input Files Specified for Unbounded Export File) and Import Aborts with IMP-00000 (Doc ID 1917260.1)

Last updated on OCTOBER 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 7.3.4.0 to 12.1.0.2 [Release 7.3.4 to 12.1]
Oracle Database - Personal Edition - Version 7.3.4.0 to 12.1.0.2 [Release 7.3.4 to 12.1]
Oracle Database - Standard Edition - Version 7.3.4.0 to 12.1.0.2 [Release 7.3.4 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Information in this document applies to any platform.
NOTE: In the images and/or the document content below, the user information and data used represents fictitious data.
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Symptoms

1. You have exported a schema from your source database with the original export client:

$ exp system/<PASSWORD> file=exp_s.dmp log=exp_s.log owner=scott

2. Upon import into the target database with the original import client, the following errors occur:

$ imp system/<PASSWORD> file=exp_s.dmp fromuser scott touser scott data_only=Y

Import: Release 11.2.0.4.0 - Production on Wed Aug 13 19:22:30 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V11.02.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
IMP-00085: multiple input files specified for unbounded export file
IMP-00000: Import terminated unsuccessfully

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.