Re: AUTOEXTEND Feature and Peculiar Error Message

In article <32410fce.12619518_at_news.telecom.at>, mpammer_at_vlr.gv.at says...
>
>Hi folks
>
>Working on a RS6000 and AIX I wanted to enable the AUTOEXTEND Feature
>but I received a peculiar error:
>
>select * from v$version;
>-----------------------------------
>Oracle7 Server Release 7.2.2.4.0 - Production Release
>PL/SQL Release 2.2.2.3.0 - Production
>CORE Version 3.4.2.2.0 - Production
>TNS for IBM/AIX RISC System/6000: Version 2.2.2.0.0 - Production
>NLSRTL Version 3.1.4.4.0 - Production
>
>SQL> select name, nvl(value,'N/A') value, isdefault
> 2 from v$parameter
> 3 where name like '%compat%';
>
>NAME VALUE ISDEFAULT
>-------------------------------- -------------------- ---------
>compatible N/A TRUE
>compatible_no_recovery N/A TRUE
>
>SQL> alter database datafile '/ax04/demo/db_files/twadm04.dbf'
> 2 autoextend on
> 3 next 50M maxsize 600M
> 4 /
>alter database datafile '/ax04/demo/db_files/twadm04.dbf'
>*
>ERROR at line 1:
>ORA-00406: COMPATIBLE parameter needs to be 7.2.0.0.0 or greater
>
>My question is:
>
>If COMPATIBLE is not set in the init.ora file why does Oracle care
>about this Parameter ?
>
>Thanks
>
>Martin Pammer
>VRZ Informatik
>mpammer_at_vrz.net
>http://www.vrz.net

The default value of "COMPATIBLE" is the earliest release of Oracle. Therefore you must set it in the init.ora file with a latest version in order to use this feature.

Tan. Received on Thu Sep 19 1996 - 00:00:00 CEST