Re: Recompile invalid packages

Howard J. Rogers wrote:
>
> "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
I'm still bitter since they introduced:

dbms_obfuscation_toolkit

Was there a competition to find the longest, hardest to type package name ??? Received on Thu Nov 06 2003 - 05:34:21 CST