Re: Invalid objects in SYS

That worked perfectly Andy, thank you.

The best news is I can use this sudo-disaster to get upper management to insist on tightening Oracle security and begin taking back the database from the developers who had the control for years before I got here.

Barry

"Andy" <enzoweb_at_hotmail.com> wrote in message news:8d4033cd.0205071707.4de18568_at_posting.google.com...
> 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 Wed May 08 2002 - 06:48:49 CDT