Re: CREATE TABLESPACE

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 12 Aug 1999 08:48:58 -0700
Message-ID: <37B2ECEA.E0A8D0AD@us.oracle.com>

John

Autoextend capability came in 7.2. You need to change the compatible parameter in the init.ora file to 7.2.0 or greater and restart the instance. Then you'll be able to use the autoextend functionality.

HTH. Pete

John Edwards wrote:

> Does anyone have any idea why I'm getting this error:
>
> SVRMGR> create TABLESPACE bv401
> 2> datafile '/data/bv4/oradata/bv401_tablespace.dbf' size 30M
> 3> autoextend on
> 4> maxsize 100M
> 5> default storage
> 6> ( initial 30K
> 7> next 20K
> 8> pctincrease 1 )
> 9> ;
> create TABLESPACE bv401
> *
> ORA-00406: COMPATIBLE parameter needs to be 7.2.0.0.0 or greater
>
> TIA
>
> John

--
Regards

Pete

Received on Thu Aug 12 1999 - 10:48:58 CDT