RE: exp/imp characterset problems
- From: "Mercadante, Thomas F \(LABOR\)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <vnr1995@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 2 Nov 2006 14:19:59 -0500
This is not a character set problem.
You export from abc1 and are trying to import as ebc1.
You need to import as such:
C:\>imp ebc1/ebc1@ebc1 FILE=C:\abc1.dmp LOG=C:\log3.log STATISTICS=NONE
fromuser=abc1 touser=ebc1
Tom
--------------------------------------------------------
This transmission may contain confidential, proprietary, or privileged
information which is intended solely for use by the individual or entity to
whom it is addressed. If you are not the intended recipient, you are hereby
notified that any disclosure, dissemination, copying or distribution of this
transmission or its attachments is strictly prohibited. In addition,
unauthorized access to this transmission may violate federal or State law,
including the Electronic Communications Privacy Act of 1985. If you have
received this transmission in error, please notify the sender immediately by
return e-mail and delete the transmission and its attachments.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of vnr1995
Sent: Thursday, November 02, 2006 2:05 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: exp/imp characterset problems
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit
Production
Solaris
I am getting some problems while exporting/importing.
The client is WinXP, sqlplus 10.2
C:\> exp abc1/abc1@abc1 FILE=C:\abc1.dmp LOG=C:\log1.log
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character
set
server uses AL32UTF8 character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user ABC1
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user ABC1
About to export ABC1's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export ABC1's tables via Conventional Path ...
. . exporting table AAG_PREFS 0 rows
exported
EXP-00091: Exporting questionable statistics.
Then I changed STATISTICS to none.
C:\> exp abc1/abc1@abc1 FILE=C:\abc1.dmp LOG=C:\log2.log STATISTICS=NONE
Connected to: Oracle Database 10g Enterprise Edition Release
10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character
set
server uses AL32UTF8 character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user ABC1
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user ABC1
About to export ABC1's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export ABC1's tables via Conventional Path ...
. . exporting table AAG_PREFS 0 rows
exported
. . exporting table ANSWER 0 rows
exported
. exporting statistics
Export terminated successfully without warnings.
C:\>imp ebc1/ebc1@ebc1 FILE=C:\abc1.dmp LOG=C:\log3.log STATISTICS=NONE
Connected to: Oracle Database 10g Enterprise Edition Release
10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V10.02.01 via conventional path
Warning: the objects were exported by ABC1, not by you
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character
set
import server uses AL32UTF8 character set (possible charset conversion)
. importing ABC1's objects into EBC1
Import terminated successfully without warnings.
---------------------------------------
The import is not done.
How to change client character set? That is, how can I change it on
windows XP?
Thanks,
Ven
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
