Re: How to change the parameter COMPATIBLE to a higher value?

> >> does anybody know how to set the COMPATIBLE parameter to
> >> a higher value (8.1.0.0.0 or more) ?
> >
> >
> Maybe ... maybe not. First off the OP may have 9i in which case he can
> change the initSID.ora for the rest of his life and nothing will
> happen. The OP would need to then recompile the initSID into the
> SPFILE.
You may be correct, but the OP did mention "8.1.0.0.0" as the version, so I assumed (maybe incorrectly) that this was not a 9i database, therefore SPFILEs don't apply. Assuming my assumption was correct. ;)

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"