Re: Invalid objects in SYS

bgt0990 wrote:

> 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

I'd run the one that removes the ability of anyone to recompile any package or other object owned by SYS or SYSTEM. Failing that I would try:

DROP USER offending_user_name CASCADE;

Not knowing what is invalid likely no one can help you.

Run the following SQL and recompile the objects ad hoc.

SELECT object_name, object_type
FROM dba_objects
WHERE status = 'INVALID';

Daniel Morgan Received on Tue May 07 2002 - 15:19:40 CDT