我重启试过了,还是出现了乱码,导入的提示:
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.
解决方案 »
- 有没有oracle11g的操作手册
- 创建了oracle 函数,但是在 plsql的function中找不到,数据库中也没有这函数。
- procedure function 区别,如何在pl/sql developer中运行他们
- 登陆不了自已电脑上的management server
- plsql连接远程oracle,查询完就卡死,如何解决?
- 主表一个字段存储字典表的多个ID值时,大牛求解决方案???
- oracle9i与oracle10g 区别
- 哪位兄弟有Embarcadero SQL Tuner的中文资料啊!
- 欢迎大家讨论:如何对数据库现存数据进行质量检查,如一致性、完整性、时效性、精度等!
- 安装oracle9的时候,为什么总是出现”加载数据库时出错“的对话框??急急急急!!
- 请问别名怎么用啊,需要预先定义吗?
- 怎样用存储过程返回一可移动光标,在java里调用?
本来2个字符集不一致,那有多种方法,可以修改字符集,可以修改导出dmp文件的头使其一致。还有就是在导入和导出时,字符集设成一致。