Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Thu Nov 02 2006 - 13:04:41 CST