Re: Recompile invalid packages

"Joel Garry" <joel-garry_at_home.com> wrote in message news:91884734.0311051518.36dd5fe_at_posting.google.com...
> 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

Whilst we're bitchin' about Oracle's scripts, has anyone looked at the monstrosity that is the 'backup to trace' these days in 9i??

Thoughtful of them to provide two versions, with just one extra word and two less letters in the 'resetlogs' versus 'noresetlogs' version, no?? (Yeah, I know it's configurable which version you get, but why in God's name pander to those who can't work out the difference in the first place??).

Worse. All the 'comments' characters are stil "#"... which we loved in server manager, but which throws errors in SQL Plus. Nice of them to remember they abolished server manager in 9i, no? I mean, didn't the lights go on: here they are busy coding a totally unnecessary version of the script to be produced, but someone forgot to join the dots and twig that "#" should have been replaced by "--".

What's even worser than that, though. Very uniquely, too. The 9i script includes extra commands for dealing with Data Guard issues (standby logfiles, performance level etc)... and guess what?? They remembered to comment those lines with '--'. So now we have a bastardised script that gets half its comment characters wrong, and the other half right.

Must have been a wet Wednesday afternoon or something.

Sorry. Pet hate rant over.
Regards
HJR Received on Wed Nov 05 2003 - 17:35:07 CST