我重启试过了,还是出现了乱码,导入的提示:
Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - ProductionExport file created by EXPORT:V08.01.06 via conventional pathWarning: the objects were exported by SYSTEM, not by youimport done in WE8ISO8859P1 character set and ZHS16GBK NCHAR character set
import server uses ZHS16GBK character set (possible charset conversion)
export client uses ZHS16GBK character set (possible charset conversion)
. importing SYSTEM's objects into SOCIAL
. . importing table "RETD_EMP_NATL_INFO" 4790 rows imported
Import terminated successfully without warnings.
Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - ProductionExport file created by EXPORT:V08.01.06 via conventional pathWarning: the objects were exported by SYSTEM, not by youimport done in WE8ISO8859P1 character set and ZHS16GBK NCHAR character set
import server uses ZHS16GBK character set (possible charset conversion)
export client uses ZHS16GBK character set (possible charset conversion)
. importing SYSTEM's objects into SOCIAL
. . importing table "RETD_EMP_NATL_INFO" 4790 rows imported
Import terminated successfully without warnings.
解决方案 »
- 紧急求救,遇到鬼了,这个sql咋回事啊!!???
- 我从别的机子复制了一TT.DMP文件,导入ORACLE时,总是说找不到文件
- DAB Studio 连接不上远程数据库!!!
- 请问%type和%rowtype在定义变量时有什么不同?
- 大家好,请问关于Oracle的“时间类型”是怎样的?
- 在作插入操作时,除了单引号会引起异常外,还有哪些字符可能引起异常?
- 一般在使用ORACLE时,自动提交怎么设置
- 为什么?
- oracle 8.17 for nt 错误,如何解决!请高手指点! wait online
- Oracle 时间的问题 在线等待!
- 请问别名怎么用啊,需要预先定义吗?
- 怎样用存储过程返回一可移动光标,在java里调用?
本来2个字符集不一致,那有多种方法,可以修改字符集,可以修改导出dmp文件的头使其一致。还有就是在导入和导出时,字符集设成一致。