Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> exp/imp characterset problems

exp/imp characterset problems

From: vnr1995 <vnr1995_at_gmail.com>
Date: Thu, 2 Nov 2006 13:04:41 -0600
Message-ID: <b86c876f0611021104n3adc00e3s698a8842293e58ac@mail.gmail.com>


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_at_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_at_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_at_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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 02 2006 - 13:04:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US