www.Orasql.Com
 
用户名: 密码:  验证码: 注册|找回密码 oracleawen's blog  
 
         当前位置 >> 技术论坛  发表帖子     论坛版块     查找帖子
求助!【comment乱码】expdp/impdp之后comment中文乱码,数据显示正常-技术论坛||Oracle高手之路—Orasql.Com!
            求助!【comment乱码】expdp/impdp之后comment中文乱码,数据显示正常
 
发贴人:oracle_awen
oracleawen@gmail.com448315233127.0.0.1
用户级别:管理员
发贴总数:1245
注册时间:2011-05-05 09:23:03
2011-06-01 08:15:45
求助!【comment乱码】expdp/impdp之后comment中文乱码,数据显示正常 问题描述用expdp导出一个schema下面所有对象,然后用impdp导入到另外一个schema之后,一个表的中文comment乱码,但是表里的中文数据正常。 expdp test/test directory=demodump dumpfile=demo24.dmp parallel=4 impdp w54/w54 directory=demodump dumpfile=demo24.dmp remap_schema=testw54 parallel=4 exclude=statistics 正确 if curr_sym_place =0 then 0 means -¥1.1 1 means ¥-1.1 2 means ¥1.1- if curr_sym_place =1 then 0 means -1.1¥ 1 means 1.1-¥ 2 means 1.1¥- of course depend minus_sym such as or , such as am or 上午 such as 下午 or pm 错误 if curr_sym_place =0 then 0 means -��1.1 1 means ��-1.1 2 means ��1.1- if curr_sym_place =1 then 0 means -1.1�� 1 means 1.1-�� 2 means 1.1��- of course depend minus_sym such as or , such as am or �� such as �� or pm 环境描述系统 centos 5.4 x86_64 数据库 11.2.0.1 64bit 系统变量 $ echo $nls_lang american_america.al32utf8 数据库字符集 sql> select from nls_database_parameters; parameter value ------------------------------ -------------------------------------------------------------------------------- nls_language american nls_territory america nls_currency $ nls_iso_currency america nls_numeric_characters ., nls_characterset al32utf8 nls_calendar gregorian nls_date_format dd-mon-rr nls_date_language american nls_sort binary nls_time_format hh.mi.ssxff am nls_timestamp_format dd-mon-rr hh.mi.ssxff am nls_time_tz_format hh.mi.ssxff am tzr nls_timestamp_tz_format dd-mon-rr hh.mi.ssxff am tzr nls_nchar_characterset al16utf16 nls_dual_currency $ nls_comp binary nls_length_semantics byte nls_nchar_conv_excp false nls_rdbms_version 11.2.0.1.0 导出导入的log中没有任何报错信息,请问为何comment会有乱码? 用exp/imp导出导入就不会有乱码问题。 请各位大侠给指点指点!!!感谢! [ 本帖最后由 evan_china 于 2011-6-16 1123 编辑 ]

      
 
  
 Orasql.Com|E-Mail:oracleawen@gmail.com|Phone:15271942915|Copyright © 2011|All Rights Reserved|