huangliang0703 2015-02-05 07:29
浏览 3194

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

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

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥60 更换迈创SOL6M4AE卡的时候,驱动要重新装才能使用,怎么解决?
    • ¥15 让node服务器有自动加载文件的功能
    • ¥15 jmeter脚本回放有的是对的有的是错的
    • ¥15 r语言蛋白组学相关问题
    • ¥15 Python时间序列如何拟合疏系数模型
    • ¥15 求学软件的前人们指明方向🥺
    • ¥50 如何增强飞上天的树莓派的热点信号强度,以使得笔记本可以在地面实现远程桌面连接
    • ¥20 双层网络上信息-疾病传播
    • ¥50 paddlepaddle pinn
    • ¥20 idea运行测试代码报错问题