Re: Recompile invalid packages

Brian Peasland <dba_at_remove_spam.peasland.com> wrote in message news:<3FA922E9.FC06AA50_at_remove_spam.peasland.com>...
> In addition to the other fine answers, also look at
> ORACLE_HOME/rdbms/admin/utlirp.sql to recompile all invalid objects.

The utlip.sql script that that script calls is so illuminating! In 8i, it shows how to deal with ORA-1555, in 9i, it shows how to deal with... blowing rollback segments! (I can understand why, the script might be run under non-undo conditions, it just sounds funny amid the undo hype). rownum < 5000, indeed.

And why do they do a commit before a drop table? Could it be they can't count on DDL doing a commit? :-O

jg

--
@home.com is bogus.
Descriptive Intermediate Attributed Notation for Ada