Re: init.ora parm COMPATIBLE

From: Brent <bpathakis_at_yahoo.com>
Date: 17 Oct 2002 12:07:18 -0700
Message-ID: <1736c3ae.0210171107.310ece6c@posting.google.com>

rainer.hirthammer_at_software-objects.com (Rainer Hirthammer) wrote in message news:<3daeccba.17234121_at_news.btx.dtag.de>...
> 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

Generally, yes. But it depends on the features you are using. If your application uses features that exit in later versions you would need to change it.

Just my opionion, though, I like to set it at 8.1.6 or higher... some of the features available in 8.1.5 and up can be very useful such as using
alter table <table_name> move tablespace .l.. to rebuild tables in different tablespaces. Received on Thu Oct 17 2002 - 14:07:18 CDT