DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Threaded View

  1. #1
    Join Date
    Mar 2002

    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 01: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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.