Re: ORA-00406 Error

The default setting in the Parameter file for COMPATIBLE is "nothing", the DBA must change the init<sid>.ora/Parameter file to reflect the desired setting.

Satar Naghshineh
SatarNag_at_worldsite.com
Wayne Belles wrote:
>
> 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
>
> The error is stating that the COMPATIBLE parameter of the initialization
> parameter file must be set to use that command. The reason is that the
> command contains syntax that was first available in 7.2. I belive
> default compatiblity is 7.0. If you wish to use functionality that is
> in a version higher than 7.0 you must set the parameter to that
> version.
>
> For example, if you wish to use the 'AUTOEXTEND' feature of Oracle you
> have to set the COMPATIBLE parameter to 7.2.0.0.0 which is the first
> version that had that feature. If you wish to use a feature that was
> first avaliable in 7.3 then you should set it to 7.3.0.0.0.
>
> --
> ++++++++++++++++++++++++++++++++++++
> Enjoy the ride,
> Wayne G. Belles
> ++++++++++++++++++++++++++++++++++++
  Received on Tue Aug 26 1997 - 00:00:00 CDT