From: "Dante A. Notari-Locher" <dnotari@cso.at>
Subject: Re: ORA-00406
Date: 1997/08/08
Message-ID: <33EB196A.21862C87@cso.at>#1/1
References: <33E6BF66.5F01@epa.ericsson.se>
X-Priority: 3 (Normal)
Organization: CSO.Net Telecom Services, http://www.cso.net
Newsgroups: comp.databases.oracle.server



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.