Re: update sys tables sets idiot flag?

In our last gripping episode jdarrah_co_at_my-deja.com wrote:
> Just to clarify, I have no plans to update the DD. I was in an Oracle
> Internals training about a year ago and the instructor mentioned that
> an idiot flag was set if the DD was updated. At the time, this
 sounded
> like a scare tactic. Sort of like when a parent tells his kid that
> people who smoke pot will definately turn into heroine addicts. Just
> trying to seperate truth from fiction.
>
> In article <t7u69nkhieml90_at_beta-news.demon.nl>,
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> > I don't think there is an idiot flag.
> > However you have a 90+ percent chance the datadictionary will become
> > inconsistent, providing all kind of unpredictable results. This will
 almost
> > show immediately. Most likely if you call support, at one point in
 time they
> > will ask 'You didn't update the datadictionary yourself, did you'.
 Whether
> > you lie at this or not doesn't really matter: there are for
 understandable
> > reasons no integrity constraints on the datadictionary, so they will
 be
> > unable to resolve it.
> > So, IMO, it is still is: it is completely stupid to even consider
 doing
> > this, unless you really *want* to loose your job.
> >
> > Regards,
> >
> > Sybrand Bakker, Oracle DBA
> >
> > <jdarrah_co_at_my-deja.com> wrote in message
> > news:95n1bj$dut$1_at_nnrp1.deja.com...
> > > I have heard from several sources that if you directly update sys
 owned
> > > tables that the database becomes unsupported. I realize that
 updating
> > > the data dictionary is a really stupid thing to do, but I was just
> > > wondering if a flag actually gets set that would inform Oracle
 Support
> > > that the data dictionary was manually updated?
> > >
> > > Thanks
> > >
> > >
> > > Sent via Deja.com
> > > http://www.deja.com/
> >
> >
>
> Sent via Deja.com
> http://www.deja.com/
>

Sometimes the Oracle instructors pass on "urban legends" as fact and the students are worse for it. It has happened to me.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/