Hi,
if your 9i has a spfile then the way to change this permanent is
Your parameter in this case cannot changed immediately
ALTER SYSTEM [param] = [val] SCOPE=SPFILE;
Then restart db an all is ok.
You now can create for documentation the init.ora from spfile
! If spfile exists then the init.ora is ignored!
Orca
![]()




Reply With Quote