|Regarding IMPORT .... [message #184431]
||Wed, 26 July 2006 09:28
Registered: February 2006
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 22.214.171.124.0 - 64bit Production
With the Partitioning option
JServer Release 126.96.36.199.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 188.8.131.52.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 184.108.40.206.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 220.127.116.11.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.