huangliang0703
2015-02-05 07:29 阅读 3.1k

oracle 11.2.0.1升级到11.2.0.4

SQL> @?/rdbms/admin/utlu112i.sql
………………
Miscellaneous Warnings


WARNING: --> Database is using a timezone file older than version 14.
.... After the release migration, it is recommended that DBMS_DST package
.... be used to upgrade the 11.2.0.1.0 database timezone version
.... to the latest version which comes with the new release.

在升级模式下执行:

SQL> EXEC DBMS_DST.BEGIN_PREPARE(14);

PL/SQL procedure successfully completed.

SQL> EXEC DBMS_DST.END_PREPARE;

PL/SQL procedure successfully completed.

SQL> EXEC DBMS_DST.BEGIN_UPGRADE(14);
BEGIN DBMS_DST.BEGIN_UPGRADE(14); END;

*
ERROR at line 1:
ORA-00904: "VIRTUAL_COLUMN": invalid identifier
ORA-06512: at "SYS.DBMS_DST", line 113
ORA-06512: at "SYS.DBMS_DST", line 1101
ORA-06512: at line 1

找不到出错的原因,求大侠们帮忙?

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

相关推荐