Re: update sys tables sets idiot flag?

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