Re:紧急求救:oracle的数据导入!

王朝oracle·作者佚名  2008-05-19
宽屏版  字体: |||超大  

Hi. There are three possible conversions when exporting and importing:

1) from the source database character set to the user session character set(based on setting for NLS_LANG during export)

2) from the export file character set to the user session character set base

d on the setting for NLS_LANG during import)

3) from the user session character set (criteria noted in #2) to the target database character set.I would suspect that the user session character set during import is not the same as the character set of the export file. The conversion noted in #2 above is only valid for single-byte character sets. For multibyte character sets, the import file's character set must be identical to the export file's character set.

【 在 GuitarCool (铿铿吉他) 的大作中提到: 】

我在执行以下的导入语句的时候出现了问题,望高手指点,先谢谢了!

F:\pb\construct\db-empIMP JHK/JHK FILE=JHK FROMUSER=JHK TOUSER=JHK Import: Release 8.1.7.0.0 - Production on 星期六 11月 17 16:31:19 2001(c) Copyright 2000 Oracle Corporation. All rights reserved.连接到: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production IMP-00016: 不支持要求的字符集转换(从类型1到852)

IMP-00000: 未成功终止导入

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
© 2005- 王朝网络 版权所有