OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » IMP-00085 (sun4u - 5.9 - Oracle 10.2.0.4.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

IMP-00085 [message #540088]

Fri, 20 January 2012 04:07

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

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator