Re: question on COMPATIBLE parameter

In your init.ora file put the following line:

compatible = 7.3.2.1.0

This will take care of the problem once you bounce the instance. (shutdown and restart).

Kenny Gump

lokikal_at_my-dejanews.com wrote in message <7ii5r8$n3p$1_at_nnrp1.deja.com>...
>Hi,
>In our database installation, we create a
>database instance without specifying
>the value for parameter COMPATIBLE.
>We are using oracle7 server Release 7.3.2.1.0
>on solaris 2.6
>From the svrmgrl prompt, as sysdba, when I tried
>the following:
>alter rollback segment rbs_1 storage (optimal 2M
>maxextents 605);
>
>...I got the following error:
>ORA-00406: COMPATIBLE parameter needs to be
>7.3.0.0.0 or greater
>
>Also when I tried
>alter database datafile 'xxx.dbf' resize 120M
>I got the same type of COMPATIBLE error as above
>(well this time the figure was 7.2.2.0.0)
>
>Can one of the oracle gurus out there help me
>decipher this error? I could not find much
>information on this parameter from oracle manuals.
>
>As to why I am changing rollback segment storage
>settings, it is the solution that I was trying
>out for a different problem that I encountered
>in my application. If it is necessary, I will
>post the details of this problem.
>
>Thanks
>laks
>
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Thu May 27 1999 - 06:45:09 CDT