Re: COMPATIBLE parameter

From: Matthias Hoys <anti_at_spam.com>
Date: Sat, 10 Dec 2005 23:45:42 +0100
Message-ID: <439b5a99$0$9070$ba620e4c@news.skynet.be>

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1134240062.943709_at_jetspin.drizzle.com...
> Matthias Hoys wrote:
>> I have a Oracle 9.2.0.5.0 db with COMPATIBLE = 9.2.0.7.0 ???
>>
>> This can only be changed manually, no ?
>
> Correct. Either by modifying the init.ora and recompiling the spfile
> or patching to 9.2.0.7.
>
> Personally I'd choose the later path.
> --

Are you sure installing a patch changes the compatible parameter ? I did an upgrade of 9.2.0.6.0 to 9.2.0.7.0 and I believe COMPATIBLE was still set to 9.2.0.6.0.

Matthias Received on Sat Dec 10 2005 - 16:45:42 CST