RE: NLS_DATE_FORMAT

From: Ken Naim <kennaim_at_gmail.com>
Date: Tue, 2 Sep 2008 11:36:07 -0400
Message-ID: <0598B419EA3746AA9B9416B5485BC299@KenPC>

Alter session/system will work. It is an instance parameter and not a db parameter.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of John Dunn
Sent: Tuesday, September 02, 2008 11:30 AM To: oracle-l_at_freelists.org
Subject: NLS_DATE_FORMAT

Can I have different values for NLS_DATE_FORMAT for different databases(ORACLE_SIDs)??

If so, do I have to set it in the spfile since ALTER DATABASE.......... does not work..

John Dunn

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 02 2008 - 10:36:07 CDT

This message: [ Message body ]
Next message: Riyaj Shamsudeen: "Re: Tracking down NOLOGGING objects: resending"
Previous message: Riyaj Shamsudeen: "Re: Tracking down NOLOGGING objects"
In reply to: John Dunn: "NLS_DATE_FORMAT"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message