Rerun catalog.sql and catproc.sql
Hi all, I would like to know if I want to run catalog.sql and catproc.sql against an existing database what are the pros and cons? Please help. Thank you
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)
It is not harmful to run these against a database.
It will consume resources when running.
Fast, Cheap, Reliable... Pick Two(2)
Catalog - creates data dictionary views.
Catproc - create in built PL/SQL Procedures, Packages etc
No no harm in running. But as alapps said its time consuming as well as resource consuming.
"There is a difference between knowing the path and walking the path."
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.
Click Here to Expand Forum to Full Width