Re: INVALID objects

There is a package called DBMS_UTILITY which has a procedure named COMPILE_SCHEMA. If you were to log-in as System and perform something like the following...
SQL> exec dbms_utility.compile_schema('SYS'); you should get everything that is invalid recompiled at least once. Sometimes recompiling one invalid object will cause others to go invalid, so it may take a few times to get it all straight.

Nobody <nobody_at_anyone.com> wrote in message news:8cl23o$ju1$1_at_diana.bcn.ttd.net...
> Hi all,
> when I make a select from all_objects Ive found some objects with INVALID
> status, and are own by sys!!, so what can I do? may i compile all? Have
> someone a great script to do this until there are no more INVALID
 objects??
>
> --
> Saludos.
> jorge_at_tice.es
>
>
Received on Sat Apr 08 2000 - 00:00:00 CDT