Re: ORA-00406

try --
In your init.ora uncomment the COMPATIBLE parameter and set it to 7.2.3.0.0
Then shutdown and startup oracle again.

Good luck

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.

--
eric kamradt
hm: (801) 567-0912
mailto: kamradt_at_inconnect.com
http://www.inconnect.com/~kamradt/resume.html