源端: 192.168.6.10 db
目标端:192.168.6.11 db10g
从192.168.6.10中exp导出两张表,其中通过scp将dmp文件拷贝至192.168.6.11服务器后imp导入错误,提示文件头有异常
源端服务器导出如下:
[oracle@db ~]$ exp test/test file='/home/oracle/test.dmp' tables=t1,test
Export: Release 11.2.0.4.0 - Production on Thu Mar 24 12:57:18 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table
目标端:192.168.6.11 db10g
从192.168.6.10中exp导出两张表,其中通过scp将dmp文件拷贝至192.168.6.11服务器后imp导入错误,提示文件头有异常
源端服务器导出如下:
[oracle@db ~]$ exp test/test file='/home/oracle/test.dmp' tables=t1,test
Export: Release 11.2.0.4.0 - Production on Thu Mar 24 12:57:18 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table