Rerun catalog.sql and catproc.sql
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Rerun catalog.sql and catproc.sql

  1. #1
    Join Date
    Mar 2001
    Posts
    149

    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

  2. #2
    Join Date
    Jul 2002
    Location
    California
    Posts
    128
    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.
    alapps

    Fast, Cheap, Reliable... Pick Two(2)

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  4. #4
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width