Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> NLS_DATE_FORMAT: how to make setting persistent?

NLS_DATE_FORMAT: how to make setting persistent?

From: Tim Romano <tim_at_ot.com>
Date: Sun, 14 Mar 1999 09:13:53 -0500
Message-ID: <36EBC421.919A4B00@ot.com>


I'm a front-end application developer who has to do some DBA tasks now and then. While I know how to change the NLS_DATE_FORMAT in a session, we want to make it persistent. How does one safely change the INITxxxx.ORA settings so the format persists? Is there a text file that has to be edited? (I can see these values in TOAD from the View menu; can they be changed from within TOAD?) Do I have to bring the system down and back up again for the changes to stick?
Thanks for the help.
Tim Received on Sun Mar 14 1999 - 08:13:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US