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

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

RE: exp/imp characterset problems

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Thu, 2 Nov 2006 14:19:59 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08811@EXCNYSM0A1AJ.nysemail.nyenet>


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_at_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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of vnr1995 Sent: Thursday, November 02, 2006 2:05 PM To: oracle-l_at_freelists.org
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_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
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 02 2006 - 13:19:59 CST

Original text of this message

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