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
Printable View
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)
Pros:
It is not harmful to run these against a database.
Cons:
It will consume resources when running.
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.
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.
HTH