Changing the Compatible parameter

From: Stephen B <stephen.bell_at_cgi.ca>
Date: Thu, 31 Jan 2002 09:05:56 -0500
Message-ID: <1dc68.20129$yi5.2950095@news20.bellglobal.com>

Oracle 8.1.7 on NT..

Hello all.........

Our client has recently upgraded to 8.1.7 but has set up development databases with the Compatible parameter set to 8.0.5.0.

In one of the scripts I tried to run, I wanted to drop a column from a table and it wouldn't allow me to...the error said I needed to set the Compatible parameter to a later version..okay, so I checked Oracle online docs and it tells me it's a Static parameter...again, that's fine.

I understand the purpose of the Compatible parameter but I don't understand the implications of changing it...in this specific case, the production version
of the application runs on 8.0.5.0 but we're developing the new version in 8.1.7..

Should I leave well enough alone and keep the parameter the way it is, or should I try to change it?

Any thoughts are much appreciated!

Steve Received on Thu Jan 31 2002 - 08:05:56 CST