10.2.0.4 的源端数据库导入到11.2.0.4 目的端数据库
需要使用10.2.0.4版本的客户端EXP导出源端数据库,使用11.2.0.4版本的IMP导入到目的端数据库
不能使用11.2.0.4的客户端直接EXP导出源端数据库,要想实现,需要打补丁。
11.2.0.4的源端数据库导入到10.2.0.4目的端数据库
可以使用10.2.0.4版本的客户端EXP导出源端数据库,使用10.2.0.4版本的IMP导入到目的端数据库
以下是使用11.2.0.4的客户端直接EXP导出源端数据库的报错信息:
C:\Users\zylong>exp TEST/test@10grac1 owner=TEST file=H:\test0811.dmp log=H:\log
_test0811.log
Export: Release 11.2.0.4.0 - Production on Thu Aug 11 15:04:27 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user TEST
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user TEST
About to export TEST's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export TEST's tables via Conventional Path ...
EXP-00008: ORACLE error 904 encountered
ORA-00904: "POLTYP": invalid identifier
EXP-00000: Export terminated unsuccessfully