UNABLE to change NLS_DATE_FORMAT. Please HELP
I am using Oracle 9i and am issuing this command -
alter system set nls_date_format = 'YYYY/MM/DD';
I have logged in through SQL PLUS as - Conn SYS as SYSDBA.
I am getting the the following error:
ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this option
I even tried -
alter database set nls_date_format = 'YYYY/MM/DD';
It gives the following error -
ERROR at line 1:
ORA-02231: missing or invalid option to ALTER DATABASE
Please help, as I need to change the date format at the database level.