Home -> Usenet -> comp.databases.oracle -> AUTOEXTEND Feature and Peculiar Error Message

AUTOEXTEND Feature and Peculiar Error Message

From: Martin Pammer <mpammer_at_vlr.gv.at>
Date: 1996/09/19
Message-ID: <32410fce.12619518_at_news.telecom.at>#1/1 







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
Received on Thu Sep 19 1996 - 00:00:00 CEST












Original text of this message