这个问题好几天了,试了很多办法也解决不了,求大神给看看,非常感谢啊啊问题描述:
从一个数据库exp导出表到另一个数据库,可以正常导出,但是导入的时候报如下错误:
mport: Release 10.2.0.4.0 - Production on Sun Sep 6 16:32:35 2015
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options
Export file created by EXPORT:V09.02.00 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character setMemory fault(coredump)
导表语句:
exp 用户名/密码@实例 TABLES=表名 file=/zj_test2.dmp grants=y
imp 用户名/密码@实例 file=/zj_test2.dmp fromuser=用户名A touser=用户名B tables=表名
导出EXP工具版本:
Release 9.2.0.8.0
导入IMP工具版本:
Release 10.2.0.4.0
导出数据库服务器字符集:
ZHS16GBK
导入数据库服务器字符集:
ZHS16GBK 导出客户端字符集:
echo $NLS_LANG
american_america.zhs16gbk导入客户端字符集:
$ echo $NLS_LANG
AMERICAN_AMERICA.ZHS16GBK
从一个数据库exp导出表到另一个数据库,可以正常导出,但是导入的时候报如下错误:
mport: Release 10.2.0.4.0 - Production on Sun Sep 6 16:32:35 2015
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options
Export file created by EXPORT:V09.02.00 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character setMemory fault(coredump)
导表语句:
exp 用户名/密码@实例 TABLES=表名 file=/zj_test2.dmp grants=y
imp 用户名/密码@实例 file=/zj_test2.dmp fromuser=用户名A touser=用户名B tables=表名
导出EXP工具版本:
Release 9.2.0.8.0
导入IMP工具版本:
Release 10.2.0.4.0
导出数据库服务器字符集:
ZHS16GBK
导入数据库服务器字符集:
ZHS16GBK 导出客户端字符集:
echo $NLS_LANG
american_america.zhs16gbk导入客户端字符集:
$ echo $NLS_LANG
AMERICAN_AMERICA.ZHS16GBK
http://www.xifenfei.com/2012/05/%e4%bd%bf%e7%94%a8expimp-%e5%af%bc%e5%85%a511g%e6%95%b0%e6%8d%ae%e5%88%b09i.html