Re: init.ora parm COMPATIBLE

From: Marc Blum <marc_at_marcblum.de>
Date: Fri, 18 Oct 2002 08:36:35 +0200
Message-ID: <0oavqu0a0inb7v91rpvanjcc8i63oqd6g7@4ax.com>

On Thu, 17 Oct 2002 14:47:56 GMT, rainer.hirthammer_at_software-objects.com (Rainer Hirthammer) wrote:

>We run RDBMS 8.1.7 and have to force compatibility to version 8.0.5.
>Is it sufficient to set the parameter 'compatible' at init.ora to
>8.0.5?
>
>Tanks, Rainer

Why do you have to force it?

The only reason I can imagine is: To avoid programmers to use 8.1.x-features Recommendation: Develop a 8.0.x-Database!

We had a 8.1.6 running with compatible=8.0.5. Funnily this one worked:

CREATE VIEW v
AS
SELECT a
FROM t
ORDER BY a
/

which is only available from 8.1.5 on.

Marc Blum
mailto:marc_at_marcblum.de
http://www.marcblum.de Received on Fri Oct 18 2002 - 01:36:35 CDT