Include in the batch as the last command to run :

Execute dbms_utility.compile_schema('schema_name');

That would make things straight before hand


HTHU

Ankur Shah
Oracle DBA
DHR-GA

----- Original Message -----
From: "Mitchell Baldwin" <mitchell.[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, January 31, 2002 11:11 AM
Subject: Compilation on execution ?


:
: Hi
:
: I'm supporting an application, that as part of the overnight batch run
: triggers + procedures become invalid. (350 + objects)
:
: Now the consultants implementing the system say that's fine as the trigger
: and subsequent procedures will be compiled on next execution.
:
: Surely this is an overhead on transaction time, further more I'm concerned
: about this and would like to see all objects valid + enabled all the time.
:
: Any thoughts or experience's anyone ?
:
: TIA
:
: Mitch
:
:
:
: --------
: Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
: To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
: Tell yer mates about http://www.farAwayJobs.com
: By using this list you agree to these
terms:http://www.lazydba.com/legal.html
:
:
Oracle LazyDBA home page