Re: Invalid objects in SYS

Try $ORACLE_HOME/rdbms/admin/utlrp.sql

This is from the comments:

Rem utlrp.sql
Rem
Rem Copyright (c) Oracle Corporation 1998. All Rights Reserved. Rem
Rem NAME
Rem utlrp.sql - UTiLity script Recompile invalid Pl/sql modules Rem
Rem DESCRIPTION
Rem

Rem     This is a fairly general script that can be used at any time to
Rem     recompile all existing invalid PL/SQL modules in a database.

"bgt0990" <btighe_at_neometrics.com> wrote in message news:<3cd7e06b_2_at_corp-news.newsgroups.com>...
> Sometime over the weekend one of the developers had occasion to recompile
> the package STANDARD. This had the effect of invalidating every object
> (procedures, functions, views, etc). I have run catproc, and catrep to get
> most of the SYS objects back but there are still a number of them left
> invalid.
>
> Which 'CAT' scripts should I run and in what order to have the best chance
> of a clean SYS schema?
>
> Thanks
> Barry
Received on Tue May 07 2002 - 20:07:02 CDT