Alter system set <parameter_name> = <parameter_value> scope = spfile; Or if you want the change to be immediate (as is permitted) you can put scope=both at the end -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Smith, Ron L. Sent: 10 June 2004 15:52 To: oracle-l@xxxxxxxxxxxxx Subject: Change NLS parameter in 9.2 on spfile I am trying to change my NLS parameter in the init file. I am new to 9.2 and I am using an spfile. Can anyone help me with the syntax or procedure to make this change? Should be simple, but it doesn't want to work. Thanks! Ron ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------