Re: ORA-00406 Error

Easy Answer... You are createing a table with the "Auto Extend" option. This option allows the tablespace to grow if needed (as long as you have the disk space). However, this option is supported on ORacle 7.2 or higher. If you have Oracle 7.2 or Higher, then edit your Parameter/init<sid>.ora File for the COMPATIBLE setting, make sure it's set to 7.2 if the COMPATIBLE setting does not exists, create it. If you are useing Oracle version 7.1 or lower, you are unable to use the "AUTO EXTEND" option.
Our Parameter file is located In our UNIX system in /home/oracle/orahome/dbs/initora7.ora

If you require further assistance, E-mail me. Hope it helped. Satar Naghshineh
SatarNag_at_worldsite.com
Tillmann Cordes wrote:
>
> Sorry, I'm quite new...
>
> After Installing Oracle 7.3 / Solaris, I want to create a Tablespace
> with
>
> "CREATE TABLESPACE Toxi_data
> DATAFILE 'ToxData' SIZE 102400K AUTOEXTEND ON NEXT 10240K
> MAXSIZE UNLIMITED
> DEFAULT STORAGE(INITIAL 100K
> NEXT 100K
> MINEXTENTS 50
> MAXEXTENTS 50
> PCTINCREASE 50)
> OFFLINE
> PERMANENT"
>
> This causes an error "ORA-00406: COMPATIBLE parameter needs to be
> 7.2.0.0.0 or greater"
>
> Why?
>
> Thanks a lot!
> -------------------------------
> Dipl.-Inform. Tillmann Cordes
> Vergiftungsinformationszentrale
> Universitaets-Kinderklinik
> Mathildenstr. 1
> D-79106 Freiburg im Breisgau
Received on Thu Aug 28 1997 - 00:00:00 CDT