Rerun catalog.sql and catproc.sql
来源:互联网 发布:知聊多久提现 编辑:程序博客网 时间:2024/05/16 09:55
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';
- Rerun catalog.sql and catproc.sql
- sql server 2005 T-SQL ALTER FULLTEXT CATALOG (Transact-SQL)
- COM Plus Catalog Requirement error during SQL Server install
- 无法成功执行catalog.sql,ORA-04045 ORA-04064
- DB2 Directory and Catalog
- Database catalog and schema
- ORACLE SQL and SQL*PLUS
- ORACLE SQL and SQL PLUS
- Rerun DTE BI Env and Refresh Hudson Preflight Env
- db2 command and sql
- sql and oracle compress
- sql : try and transaction
- oracle sql and package
- sql offline and online
- sql between and
- T-SQL between and
- SQL AND & OR
- sql 中 and or
- 面向对象设计原则 面向对象设计原则之依赖倒转原则
- Quartz实例Demo
- Typescript笔记1 安装和基础类型
- Unity炸弹爆炸伤害(群攻伤害)
- MySQL专用名词
- Rerun catalog.sql and catproc.sql
- 果然,坚持写博客还是一件比较困难的事
- 用素质去鼓励,用体制去保障,用监督去落实,用行动去反馈
- iOS项目分析及优化
- android--关于内部存储、外部存储以及存储路径
- 里氏替换原则 转1
- 一句话说明
- 设计模式-观察者模式
- svn项目突然没有了svn怎么办