-
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.
Last edited by quester; 11-27-2002 at 02:04 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|