Rerun catalog.sql and catproc.sql

最新推荐文章于 2021-05-08 09:22:55 发布

翻译最新推荐文章于 2021-05-08 09:22:55 发布 · 958 阅读

oracle入门专栏收录该内容

43 篇文章

订阅专栏

本文介绍如何使用catalog.sql和catproc.sql脚本来维护Oracle数据库，包括创建数据字典视图及内置PL/SQL过程等，并提供了步骤指导如何处理无效对象。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Rerun catalog.sql and catproc.sql

在open下，conn / as sysdba

Catalog - creates data dictionary views.

Catproc - create in built PL/SQL Procedures, Packages etc

catalog.sql and catproc.sql are used to create/recreate database internal views/procedures/packages, etc...

They are primarily used after applying a patch/patchset to the database (Refer to instructions of your specific patch/patchset)

Pros:
It is not harmful to run these against a database.

Cons:
It will consume resources when running.

running catalog and catproc will make your packages/procedures invalid. You will have to recompile them.
You can use utlrp.sql which you can find in $ORACLE_HOME/rdbms/admin. Or you could run utlrmp.sql and recompile ( in parallel ) using the provided procedure.

1. SQL> @catalog.sql

2. SQL> @catproc.sql

3. Check for invalids from dba_objects:

SQL> select owner, object_name from dba_objects where status='INVALID';

4. Run utlrp.sql:
SQL> @utlrp.sql

5. Check for invalids again.

SQL> select owner, object_name from dba_objects where status='INVALID';