Re: Script to find all invalid objects and recompile

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 11 Dec 2000 19:34:54 -0000
Message-ID: <976563132.19970.1.nnrp-14.9e984b29@news.demon.co.uk>

Oracle Corp. supplies one of these -
If I recall correctly it is:

$ORACLE_HOME/rdbms/admin/utlrp.sql

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
Book bound date: 8th Dec 2000
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Daniel Navarro <"dnavarro"@intervoice.com> wrote in message
<3a3108e9.0_at_208.200.21.197>...


>

>Hi all,

>

>Does anyone have a script that will go out and find all invalid objects

>and

>recompile them.  Every time I alter a package or DB object it marks its

>dependents status as 'INVALID' even though nothing done adversely

>affects the dependent object.  I guess this is just a safeguard that

>Oracle

>puts in.  What I would really like is that every time I alter a package

>or

>database object and compile it, a script would also compile its

>dependents

>also.

>

>I am using Oracle Enterprise 8.1.6 R2 on Linux.

>

>Also does anyone know if Oracle 8.1.6 R3 comes with Enterprise Manager?

>Oracle claimed that they would bundle it with this release, but they've

>been

>known to fib.

>

>-Daniel N

>Software System Engineer

>

Received on Mon Dec 11 2000 - 13:34:54 CST