procedures and triggers recompiled automatically?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: procedures and triggers recompiled automatically?

  1. #1
    Join Date
    Apr 2001
    Posts
    257

    procedures and triggers recompiled automatically?

    This is a beginner's question:

    If after import I've found some triggers and procedures have INVALID status when querying user_objects, should I worry about it? I thought they will automatically get recompiled when being called.

    Please clarify.
    Thanks,

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    For the most part, provided they are actually valid, the objects will be compiled on request. Even so you should consider manually compiling them yourself. I've seen systems with lots of code dependencies grind to a halt due to a cascade effect of compilations.

    An easy way to do this is to use either:

    $ORACLE_HOME/rdbms/admin/ultrp.sql

    or

    DBMS_UTILITY.COMPILE_SCHEMA

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

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