错误信息变成 IMP-00016: required character set conversion (type 1 to 852) not supported IMP-00000: Import terminated unsuccessfully 我想应该换成usc7什么的了,但是我不知道缺省的英文字符集事什么
估计原来导出的数据库的字符集是英文的吧?可能会丢失数据。 IMP-00016 required character set conversion (type number to number) not supported Cause: Import could not convert the character format of the export file into the native character format. Action: Change the user character set by setting the NLS_LANG environment variable to match the character set of the export file. 试一试: AMERICAN_AMERICA.US7ASCIIgood luck
Oracel 7 常用ZHSGB282312HZ(应该是这个吧,我记不太请了) ---850
在注册表中的Oracle 项的Languge(语言)中的修改后,重新启动。
1.打开注册表,检查键值HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME1\NLS_LANG如是 SIMPLIFIED CHINESE_CHINA.ZHS16GBK
改为 SIMPLIFIED CHINESE_CHINA.ZHS16CGB231280如是 SIMPLIFIED CHINESE_CHINA.ZHS16CGB231280
改为 SIMPLIFIED CHINESE_CHINA.ZHS16GBK然后重新启动ORACLE,再导入一次,应该就没有问题了。提示无法转换字符集*(1-852)。。和 提示无法转换字符集*(1-850)。。两种错误时,
上面就是他们的解决方法,但是哪个对应哪个有点记不清了,你自己查看一下注册表就清楚了。不知道说清楚了没有。
改为 SIMPLIFIED CHINESE_CHINA.ZHS16CGB231280
出现错误提示
1-850 !!
所以SIMPLIFIED CHINESE_CHINA.ZHS16GBK ----852
SIMPLIFIED CHINESE_CHINA.ZHS16CGB231280 ----850
?????????? ----- 1
老美总喜欢把自己摆在首位。
如果你是客户端,就将注册表中的NLS_LANG分别改为AMERICAN_AMERICA.ZHS16GBK或AMERICAN_AMERICA.ZHS16CGB231280试一试。
祝好运
IMP-00016: required character set conversion (type 1 to 852) not supported
IMP-00000: Import terminated unsuccessfully
我想应该换成usc7什么的了,但是我不知道缺省的英文字符集事什么
IMP-00016 required character set conversion (type number to number) not supported
Cause: Import could not convert the character format of the export file into the native character format.
Action: Change the user character set by setting the NLS_LANG environment variable to match the character set of the export file.
试一试:
AMERICAN_AMERICA.US7ASCIIgood luck