Re: CREATE TABLESPACE

From: Trevor Pearce <trevor.pearce_at_onyx.net>
Date: Thu, 12 Aug 1999 16:28:58 +0100
Message-ID: <37B2E83A.828D26C@onyx.net>

Have you set your compatible parameter in the init<SID>.ora to an incorrect version that does not support autoextend.

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
Received on Thu Aug 12 1999 - 10:28:58 CDT