Re: ORA-00406

From: Dante A. Notari-Locher <dnotari_at_cso.at>
Date: 1997/08/08
Message-ID: <33EB196A.21862C87@cso.at>#1/1

Hi Cris !

       Default for COMPATIBLE is 7.0.0.0, so you
        need to set COMPATIBLE to 7.2.0.0


            Dante A. Notari-Locher

Chris Balakas wrote:

> Hello,
>
> I am new to Oracle and have run into a problem. I am hoping someone
> will be able to help me with what might be a simple problem.
>
> I have a datafile that I am trying to resize via:
> ALTER DATABASE DATAFILE '....' RESIZE 250M;
> When I issue the command, I get
> ORA-00406 Compatible parameter needs to be 7.2.0.0.0 or greater.
>
> I am running 7.2.3.0.0.
> My pfile has COMPATIBLE = 7.1.0.0 but it is commented out.
> PRODUCT_COMPONENT_VERSION table shows the version to be 7.2.3.0.0.
>
> Everything points to me being able to run the command, however,
> Oracle refuses to accept it.
>
> Any Suggestions ?
>
> Thank you in advance.
>
> Chris B.
Received on Fri Aug 08 1997 - 00:00:00 CDT