Re: update sys tables sets idiot flag?

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/ Received on Mon Feb 05 2001 - 16:21:15 CST