"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1069360098.420598_at_yasure...
> Niall Litchfield wrote:
> > edit the init.ora or use alter system. this should be documented at
> > http://tahiti.oracle.com
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
>
> And nothing will happen.
>
> In 9i you must recompile the init.ora into the spfile
> for the change to take effect.
Not if you are not using an spfile. In this case init.ora works just as it
always has. Admittedly I didn't mention bouncing the instance. How do you
get the change into the spfile? with the alter system command. Actually
thats how *I* get it in there I guess create spfile.... would also work.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Thu Nov 20 2003 - 15:02:22 CST
