exp/imp characterset problems
- From: vnr1995 <vnr1995@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 2 Nov 2006 13:04:41 -0600
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
Other related posts:
