考试网 >> IT认证 >> Oracle >> Oracle指导 >> Oracle数据库的转移与升级

发布时间：2006-06-28 10:08     点击：

You must run the script in the new release 9.2 environment.

You only need to run one script, even if your upgrade spans more than one release. For example, if your old release was 8.1.7, then you only need to run u0801070.sql.

The script you run creates and alters certain dictionary tables. It also runs the catalog.sql and catproc.sql scripts that come with the new 9.2 release, which create the system catalog views and all the necessary packages for using PL/SQL.

The following components are upgraded by running the uold_release.sql script:

Oracle9i Catalog Views

Oracle9i Packages and Types

Display the contents of the component registry to determine which components need to be upgraded:

SQL> SELECT comp_name, version, status

         FROM dba_registry;

The following is an example of the output you will see when issuing this query:

COMP_NAME                      VERSION          STATUS

Oracle9i Catalog Views         9.2.0.1.0        VALID

Oracle9i Packages and Types    9.2.0.1.0        VALID

JServer JAVA Virtual Machine   9.0.1            LOADED

Java Packages                  9.0.1            LOADED

Oracle XDK for Java            9.0.1            LOADED

发表评论： 匿名发表 用户名: 查看评论

您将承担一切因您的行为、言论而直接或间接导致的民事或刑事法律责任 留言板管理人员有权保留或删除其管辖留言中的任意内容 本站提醒：不要进行人身攻击。谢谢配合。