Re: Question: Invalid Objects

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 19 Feb 2003 07:08:13 +0100
Message-ID: <hp765vcikrjaki1hh5j5833gbg0m8hsage@4ax.com>

On Tue, 18 Feb 2003 17:55:14 -0800, Ron <southbayguy_at_linkline.com> wrote:

>I'm looking for a scipt that will look and an Oracle database for
>invalid objects (triggers, views, packages, etc...) and then allow me
>to re-compile them. Or a script that will just re-compile all invalid
>objects.
>
>Thanks in advance.
>
>Ron (southbayguy_at_linkline.com)

$ORACLE_HOME/rdbms/admin/utlrp.sql, needs to be run as SYS

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Feb 19 2003 - 00:08:13 CST