Home » RDBMS Server » Backup & Recovery » Regarding IMPORT ....
Regarding IMPORT .... [message #184431] Wed, 26 July 2006 09:28 Go to next message
frank.svs
Messages: 162
Registered: February 2006
Senior Member
Hi frns,

I encountered one problem while IMPORTING data from a dmp file. The has occured due to diffrenet character sets.In US our client ORACLE database on unix box. So what i have done is that i have taken user level export and when i seen the log file it has given the following warning while exporting each table

Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.7.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses US7ASCII character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user ESPS
. exporting PUBLIC type synonyms
. exporting private type synonyms

EXP-00091: Exporting questionable statistics.
. exporting statistics
Export terminated successfully with warnings.

Now i have taken that export dmp file and i tried to IMP in my local database which is running on Windows platform and i am getting following error

Import: Release 9.2.0.1.0 - Production on Wed Jul 26 18:24:13 2006

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


Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

Export file created by EXPORT:V09.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

Can anyone give a proper solution to this so that i can import the dump file in my local windows based oracle database.



Regards,
frank.





Re: Regarding IMPORT .... [message #184438 is a reply to message #184431] Wed, 26 July 2006 09:41 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> IMP-00085: multiple input files specified for unbounded export file

What do you think?
make sure you are providing the right parameters
Previous Topic: Backing up from a Schema
Next Topic: Manage Archiving on Another/Separate PC
Goto Forum:
  


Current Time: Thu Dec 08 22:20:48 CST 2016

Total time taken to generate the page: 0.28238 seconds