Howto alter(spfilexe.ora)server parameter, nls_date_language=eng, permanent
485461Mar 4 2006 — edited Mar 7 2006Hello everybody,
I'm a newbie, I'm trying to set the spfilexe.ora......for the nls_date_language=english parmenant, however unsuccessful and needing to set session each time..........
Although I have try to alter system set nls_date_language=english; -> error....
The result as follows:
SQL> alter system set nls_date_language=english;
alter system set nls_date_language=english
*
ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this
option
IN the v$spparameter,
SI NAME VALUE display_value ISSPECIF ORDINAL update_comment
-- ---------------------- -------- -------- -------- -------- --------
* nls_date_language FALSE 0
Please help, thanks a lot!
newbie v