Re: CREATE TABLESPACE

On Thu, 12 Aug 1999 15:39:40 +0100, "John Edwards" <john_at_zinc.co.uk> 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
>
>

The settings you have chosen for the tablespace require a compatibility of 7.2 or greater and it looks like your system is not comaptible to 7.2.0 yet. You can :

1. Upgrade your system to at least 7.2 if it is not already (7.3 would be better)
2. Ensure that the init.ora compatibility parameter is set to at least 7.2 if your db vers is already at least 7.2 and then issue an 'alter database reset compatibility' command
3. Remove the autoextend value from your create statement
   • Lisa