UNABLE to change NLS_DATE_FORMAT. Please HELP
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: UNABLE to change NLS_DATE_FORMAT. Please HELP

Threaded View

  1. #1
    Join Date
    Mar 2002
    Posts
    200

    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