Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: CREATE TABLESPACE

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US