从2个客户端,2个服务器,2个版本的dmp文件的角度来分析,排列组合也有2*2*2=8种了,真正把这8种情况做完试验以后,其实就是两个规则:
规则1. 低版本的exp/imp客户端可以连接到高版本(或同版本)的数据库服务器,但高版本的exp/imp客户端不能连接到低版本的数据库服务器。
规则2. 高版本exp出的dmp文件,低版本无法imp(无法识别dmp文件)
有了这两个规则,8种试验结果就变得很简单了。
排除9iclient to 9iserver, 10gclient to 10gserver.两种可能,剩下有6种可能
a. 9iclient + 9i dmp => 10g server yes
b.10client + 9i dmp => 9i server no(违反规则1)
c.10client + 9i dmp => 10g server yes
d. 9iclient + 10g dmp => 9i server no(违反规则2)
e. 9iclient + 10g dmp => 10g server no(违反规则2)
f. 10client + 10g dmp => 9i server no(违反规则1)
附加:g:9i客户端 exp 10g dmp文件 yes
h:10g客户端 exp 9i dmp文件 no(违反规则1)
详细试验情况如下:9i数据库@test_9i 10g数据库@test_10g
a. 9iclient + 9i dmp => 10g server yes
C:\Documents and Settings\wgzx1>impecc_view10/ecc@nfdbfile=c:\9i.dmp fromuser=
ecc_view9 touser=ecc_view10
Import: Release 9.2.0.1.0 - Production on 星期四 2月 26 10:16:28 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options
经由常规路径导出由EXPORT:V09.02.00创建的文件
警告: 此对象由 ECC_VIEW9 导出, 而不是当前用户
已经完成ZHS16GBK字符集和AL16UTF16 NCHAR 字符集中的导入
. . 正在导入表 "TEST1" 14113行被导入
成功终止导入,但出现警告。
b.10client + 9i dmp => 9i server no(违反规则1)
[oracle@ntkdb ~]$ impecc_view9/ecc@testdbfile=./9i.dmp full=y
Import: Release 10.2.0.1.0 - Production on 星期四 2月 26 09:52:15 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
IMP-00058: ORACLE error 6550 encountered
ORA-06550: 第 1 行, 第 33 列:
PLS-00302: 必须说明 'SET_NO_OUTLINES' 组件
ORA-06550: 第 1 行, 第 7 列:
PL/SQL: Statement ignored
IMP-00000: Import terminated unsuccessfully
c.10client + 9i dmp => 10g server yes
[oracle@ntkdb ~]$ impecc_view10/ecc@nfdbfile=./9i.dmp full=y
Import: Release 10.2.0.1.0 - Production on 星期四 2月 26 09:57:58 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V09.02.00 via conventional path
Warning: the objects were exported by ECC_VIEW9, not by you
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. importing ECC_VIEW9's objects into ECC_VIEW10
. importing ECC_VIEW9's objects into ECC_VIEW10
. . importing table "TEST1" 14113 rows imported
Import terminated successfully without warnings.
d. 9iclient + 10g dmp => 9i server no(违反规则2)
C:\Documents and Settings\wgzx1>impecc_view9/ecc@testdbfile=c:\10g.dmp full=y
Import: Release 9.2.0.1.0 - Production on 星期四 2月 26 10:51:59 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
连接到: Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
IMP-00010: 不是有效的导出文件,标题验证失败
IMP-00000: 未成功终止导入
e. 9iclient + 10g dmp => 10g server no(违反规则2)
C:\Documents and Settings\wgzx1>impecc_view10/ecc@nfdbfile=c:\10g.dmp full=y
Import: Release 9.2.0.1.0 - Production on 星期四 2月 26 10:53:18 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options
IMP-00010: 不是有效的导出文件,标题验证失败
IMP-00000: 未成功终止导入
f. 10client + 10g dmp => 9i server no(违反规则1)
[oracle@ntkdb ~]$ impecc_view9/ecc@testdbfile=./10g.dmp full=y
Import: Release 10.2.0.1.0 - Production on 星期四 2月 26 10:25:20 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
IMP-00058: ORACLE error 6550 encountered
ORA-06550: 第 1 行, 第 33 列:
PLS-00302: 必须说明 'SET_NO_OUTLINES' 组件
ORA-06550: 第 1 行, 第 7 列:
PL/SQL: Statement ignored
IMP-00000: Import terminated unsuccessfully
g:9i客户端 exp 10g dmp文件 yes
C:\Documents and Settings\wgzx1>expecc_view10/ecc@nfdbfile=c:\10g2.dmp tables=test1
Export: Release 9.2.0.1.0 - Production on 星期四 2月 26 11:52:03 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options
已导出 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集
即将导出指定的表通过常规路径 ...
. . 正在导出表 TEST1 42329 行被导出
在没有警告的情况下成功终止导出。
h:10g客户端 exp 9i dmp文件 no(违反规则1)
[oracle@ntkdb ~]$ expecc_view9/ecc@testdbfile=./9i2.dmp tables=test1
Export: Release 10.2.0.1.0 - Production on 星期四 2月 26 11:16:48 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
EXP-00056: ORACLE error 6550 encountered
ORA-06550: 第 1 行, 第 41 列:
PLS-00302: 必须说明 'SET_NO_OUTLINES' 组件
ORA-06550: 第 1 行, 第 15 列:
PL/SQL: Statement ignored
EXP-00000: Export terminated unsuccessfully
--转自