导入数据库错误,提示无法转换字符集*(865-852)。。急!!!!

不支持要求的字符集转换(从类型865到852)
原数据用的繁体操作系统,现导入简体操作系统,oracle版本都是8.1.7,
请问有什么解决办法?急!!

---------------------------------------------------------------
http://expert.csdn.net/Expert/topic/1068/1068575.xml?temp=.9360926
---------------------------------------------------------------
我想最简单的方法是:
保证export session 的nls_lang 和import session 的nls_lang 一样。
(再NT下,用修改注册表的方法:HKEY_LOCAL_MACHINE->software->oracle->NLS_Lang;
在UNIX下,设置正确的环境变量NLS_LANG ).
这样,在import 过程中,字符转换只会发生一次(当数据插入数据库时,而这个转换
是自动的)

关于如何确认export 文件的nls_lang , 请参照:
NOTE:48644.1 in metalink.oracle.com
---------------------------------------------------------------
一个方法修改EXPORT的NLS_LANG,修改DUMP文件的前几个二进制的值,可用ultredit打开来修改:
The second and the third byte in the file define the character set used for the export.
US7ASCII 0x0001
WE8DEC 0x0002
WE8ISO8859P1 0x001f
EE8ISO8859P2 0x0020
SE8ISO8859P3 0x0021
NE8ISO8850P4 0x0022
CL8ISO8859P5 0x0023
AR8ISO8859P6 0x0024
EL8ISO8859P7 0x0025
IW8ISO8859P8 0x0026
WE8ISO8859P9 0x0027
TH8TISASCII 0x0029
WE8ROMAN8 0x0005
WE8PC850 0x000a
US8PC437 0x0004
EE8PC852 0x0096
EE8MSWIN1250 0x00aa
CL8MSWIN1251 0x00ab
EL8MSWIN1253 0x00ae
WE8MSWIN1252 0x00b2
JA16EUC 0x033e
JA16SJIS 0x0340
ZHT16BIG5 0x0361


  • Please read it *

Warning: User modifications of export dump files are not supported ======== by Oracle. The character set information is also held in other places in the export dump file and modifying only the two bytes may lead to problems with imported data.

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus