传输表空间遇到ORA-00721:

来源：互联网发布：淘宝手淘搜索一下爆编辑：程序博客网时间：2024/06/07 00:55

传输表空间当进行无数据导入时，遇到了版本不一致的问题，如下：
[oracle@dbserver1 ~]$ imp \'sys/system as sysdba\' transport_tablespace=y file=exp_userstan.dmp log=imp.log tablespaces=users,tan

Import: Release 10.2.0.1.0 - Production on Mon Apr 23 01:16:20 2012

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path
About to import transportable tablespace(s) metadata...
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. importing SYS's objects into SYS
. importing SYS's objects into SYS
IMP-00017: following statement failed with ORACLE error 721:
"BEGIN sys.dbms_plugts.checkCompType('COMPATSG','10.2.0.1.0'); END;"
IMP-00003: ORACLE error 721 encountered
ORA-00721: changes by release 10.2.0.1.0 cannot be used by release 10.2.0.0.0
ORA-06512: at "SYS.DBMS_PLUGTS", line 2004
ORA-06512: at line 1
IMP-00000: Import terminated unsuccessfully

检查源库：

SQL> select * from V$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL> show parameter compatible

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 10.2.0.1.0
SQL>

检查目标库：

SQL> select * from V$version;

SQL> show parameter compatible

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 10.2.0
SQL>

发现源库和目标库的兼容性设置不一样，对目标库进行如下修改后，问题解决。

SQL> alter system set compatible='10.2.0.1.0' scope=spfile;
SQL> shutdown immediate.
SQL> startup