Re: COMPATIBILITY flag

Satar,

  Are you sure about this ? To my knowledge once you change the compatibility flag, that information get recorded in the controlfile and it prevents you from changing it back. I have tested this and found that you cannot change it back to a lesser version. I would like to know how you did this ?

Denny

In article <7dhd38$t23$1_at_nnrp1.dejanews.com>,   Satar <satar_at_my-dejanews.com> wrote:
> My apoligies on this post, it was worded wrong. I was responding to the post
> below. He was stating that if he increased this parameter and found trouble
> with it, can he set the setting back to the way it was.
>
> In my mindset, I'm thinking he increases the compatibility and decides to go
> back the same day. My response should have been, Yes you can set this
> parameter back to it's original setting (granted that you didn't create and
> use some applications that take advantage of the features of this parameter).
> I've done it many times.
>
> Regards,
> Satar
>
> Oracle DBA/UNIX System Admin
> "Opinions are the result of the voices in my head only,
> and do not reflect my employer or Oracle Corporation."
>
> In article <7deki8$fts$1_at_nnrp1.dejanews.com>,
> Satar <satar_at_my-dejanews.com> wrote:
> > There is no negative aspects of setting this parameter, your applications
> > won't be hurt or molested. And yes, you can re-set it to whatever value you
> > want.
> >
> > Regards,
> > Satar
> > Oracle DBA/UNIX System Admin
> > "Opinions are the result of the voices in my head only,
> > and do not reflect my employer or Oracle Corporation."
> >
> > In article <36FA7ED2.454B4C2_at_non-hp-usa-om46.om.hp.com>,
> > michael_rothwell_at_non-hp-usa-om46.om.hp.com wrote:
> > >
> > > If I set my COMPATIBLE flag up to 7.3.x.x.x. and find that it blows up
> > > some application, is there a problem with setting it back down to whatever
> > > it is now?
> > > --
> > > Michael A. Rothwell
> > > Oracle DBA/Oracle Web Applications Developer
> > >
> > > Views expressed here are not those of my company
> > > No - Actually - Since I am independent, They are the views of my company.
> > >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 29 1999 - 11:21:51 CST