Oracle数据库的升级(10gR2至11gR2)(三)

2015-02-02 13:34:55 · 作者: · 浏览: 61
> @?/rdbms/admin/catupgrd.sql? ---about 30 minutes
SQL> STARTUP
SQL> @?/rdbms/admin/utlu112s.sql
SQL> @?/rdbms/admin/catuppst.sql
SQL> @?/rdbms/admin/utlrp.sql
SQL> SELECT count(*) FROM dba_invalid_objects;
SQL> SELECT distinct object_name FROM dba_invalid_objects;
<<<<<<如果有失效对象,需要手工重编译