mike7411_at_gmail.com wrote:
> On Oracle 10g, I tried the following option:
>
> ALTER SYSTEM SET compatible='8.1.0' SCOPE=spfile;
>
> However, when I try to reload, it refuses to load, saying:
>
> ORA-00401: the value for parameter compatible is not supported by this
> release
>
> I don't know how to change the parameter back without the database
> being loaded.
>
> Any ideas?
SQL> conn / as sysdba
SQL> SHUTDOWN IMMEDIATE;
SQL> CREATE spfile FROM pfile='init.ora';
SQL> STARTUP;
SQL> show parameter spfile
--
Daniel A. Morgan
University of Washington
Puget Sound Oracle Users Group
Received on Wed Sep 06 2006 - 18:24:00 CDT
