| Regarding IMPORT .... [message #184431] |
Wed, 26 July 2006 09:28  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
