From: Ken Naim <>
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: [] On Behalf Of John Dunn
Sent: Tuesday, September 02, 2008 11:30 AM To:

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

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

Original text of this message