Home » RDBMS Server » Server Utilities » IMP-00085 (sun4u - 5.9 - Oracle 10.2.0.4.0)
IMP-00085 [message #540088] Fri, 20 January 2012 04:07 Go to next message
rahul1982
Messages: 53
Registered: November 2011
Location: Pune
Member
Hi All,

Machine hardware: sun4u
OS version: 5.9
Oracle Version: 10.2.0.4.0

I have export of a schema which is split in two dump files; I tried to import both dump files but getting error. please suggest.

/users/daoja/exp> cat wiucc_imp_prod
#!/bin/csh -e
#
echo    "IMPORT  USER"

setenv TWO_TASK qaccus
imp userid=prmuser/prmuser 
file=/dataproj/data/wiucc.dmp.110823aa,/dataproj/data/wiucc.dmp.110823ab 
volsize=0 buffer=524288 grants=y ignore=y indexes=y rows=y full=y commit=y recordlength=32768 
|& tee -a /dataproj/data/wiucc_imp_prod.log

echo    ">>>>>>>>>> IMPUSER  IS COMPLETE >>>>>>>>> @" `date`
/users/daoja/exp>


Error while importing.

/users/daoja/exp> ./wiucc_imp_prod
IMPORT  USER

Import: Release 9.2.0.8.0 - Production on Fri Jan 20 03:47:49 2012

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


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

Export file created by EXPORT:V09.02.00 via direct path

Warning: the objects were exported by VAUCC2, not by you

import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
IMP-00085: multiple input files specified for unbounded export file
IMP-00000: Import terminated unsuccessfully
/users/daoja/exp>


Data location -

/dataproj/data> ls  wiucc.dmp.11082*
wiucc.dmp.110823aa  wiucc.dmp.110823ab
/dataproj/data>


Thankx,
Rahul



[Updated on: Fri, 20 January 2012 04:12] by Moderator

Report message to a moderator

Re: IMP-00085 [message #540089 is a reply to message #540088] Fri, 20 January 2012 04:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
IMP-00085: multiple input files specified for unbounded export file
 *Cause:  You specified multiple file names for the FILE parameter when
            doing an import, but the header in the export file indicates that
            that the export operation could create only one file.  Specifying
            multiple file names is valid for an import operation only if the
            export files were created by an export operation in which the user
            specified a non-zero value for the FILESIZE parameter.
 *Action: If you believe the export contains multiple files, verify that
            you have specified the correct files.  If you believe the export
            should be in only one file then try the import operation again,
            but specify only one value for the FILE parameter.

Regards
Michel
Re: IMP-00085 [message #540091 is a reply to message #540089] Fri, 20 January 2012 04:18 Go to previous messageGo to next message
rahul1982
Messages: 53
Registered: November 2011
Location: Pune
Member
Thankx for the input.

It means i have to run import twice; one for wiucc.dmp.110823aa and one for wiucc.dmp.110823ab.

Thankx,
Rahul
Re: IMP-00085 [message #540094 is a reply to message #540091] Fri, 20 January 2012 04:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It means they are not part of the same export.
So, yes, try to do it in 2 imports, no guarantee it will work.

Regards
Michel
Re: IMP-00085 [message #540097 is a reply to message #540094] Fri, 20 January 2012 04:33 Go to previous messageGo to next message
rahul1982
Messages: 53
Registered: November 2011
Location: Pune
Member
Thank you!!

import completed for both files.

Thankx,
Rahul
Re: IMP-00085 [message #540099 is a reply to message #540097] Fri, 20 January 2012 04:34 Go to previous messageGo to next message
rahul1982
Messages: 53
Registered: November 2011
Location: Pune
Member
import submitted twice.
Re: IMP-00085 [message #540100 is a reply to message #540099] Fri, 20 January 2012 04:45 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.

Regards
Michel
Previous Topic: Dump file generation
Next Topic: Error during expdp on Oracle 11gR2 on Solaris
Goto Forum:
  


Current Time: Thu Mar 28 10:28:03 CDT 2024