this parameter is not dynamic, you have to shutdown the db. Also add to the
end ' scope = spfile;

-----Original Message-----
From: Declan Heerey
[mailto:oracledba-ezmlmshield-x50028630.[Email address protected]
Sent: Tuesday, November 30, 2004 8:12 AM
To: LazyDBA Discussion
Subject: RE: NLS_DATE_FORMAT


I don't think you can set NLS_DATE_FORMAT for the system dynamically. As far
as i know you set it in the init.ora and have to bounce the database for it
to be set.

Anyone else know any better?

-----Original Message-----
From: Rupesh Shah
[mailto:oracledba-ezmlmshield-x71416616.[Email address protected]
Sent: 30 November 2004 13:00
To: LazyDBA Discussion
Subject: NLS_DATE_FORMAT


How to change nls date format for the database.?



Below command does not work

alter system set NLS_DATE_FORMAT = 'MM/DD/YYYY';



Regards,

rupesh



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


_____________________________________________________________________
This e-mail has been scanned for viruses by MCI's Internet Managed Scanning
Services - powered by MessageLabs. For further information visit
http://www.mci.com

_____________________________________________________________________
This e-mail has been scanned for viruses by MCI's Internet Managed Scanning
Services - powered by MessageLabs. For further information visit
http://www.mci.com


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page