Re: COMPATIBILITY parameter

Karen Byrd wrote:

> We got a "ORA-00406 COMPATIBILITY parameter needs to be 7.3.0.0.0 or
> higher" error while trying to create a tablespace.
>
> We understand what the error means but not how to fix it.
>
> Also when I installed version 7.3.2.3.2(OpenVMS) this was a fresh
> install
> not an upgrade from version 7.1 so I don't understand why we are
> getting
> the error in the first place.
>
> But we do need to know exactly how to set the COMPATIBILTY parameter
> after the fact.
>
> TIA
>
> --
> Karen Byrd

The compatibility is set in your init<sid>.ora:

compatible=7.3.0.0.0

If compatible is not set (or commented out) it defaults to 7.0.12

This parameter allows you to use a newer software release and maintain backward
compatibility with earlier releases. However, some of the features of the new release
will not be available to you.

The features of the different levels of compatibility include:

7.1.0.0.0 read-only tablespaces, multiple same-type triggers on a table

7.1.5.0.0    direct reads
7.2.0.0.0    improved hash functions, resizable datafiles
7.3.0.0.0    standby DB, unlimited extents, temporary tablespace
7.3.3.0.0    bitmapped indexes

My guess is that you have tried to create a tablespace with unlimited extents which
requires compatible set to 7.3.0.0.0 or higher.

/Jesper

--
.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.

|
|
|                            Jesper
 Søndergaard                              |
|                            Technical
 Analyst                              |
|
|
| Email:     jsoender_at_dk.oracle.com                 Oracle
 Danmark           |
| Office:    +45 4480 8081                          Lautrupbjerg
 2-6         |
| Direct:    +45 4480 4269                          DK-2750
 Ballerup         |
|
|
'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'

         The statements and opinions expressed here are my own and
         do not necessarily represent those of Oracle Corporation.