Hi Rajesh,

Yeah, NLS_DATE_FORMAT cannot be set at system level. So you have to make the
change in init.ora and can create new spfile. But at the same time, make
sure that you don't have any parameter set in spfile, which is not in
init.ora, otherwise those changes will be lost. So you can put them in
init.ora also, when you will bounce the database.

I hope that it will be clear.

Regards,

Mohit Singla, Valu America Inc.,113 Technology Drive,Pittsburgh, PA, 15275
Tel: - 412-494-0400 Ext. 8107


-----Original Message-----
From: KANCHIS RAJESH
[mailto:oracledba-ezmlmshield-x41189162.[Email address protected]
Sent: Wednesday, August 04, 2004 1:34 AM
To: LazyDBA Discussion
Subject: Oracle startup parameters -reg

Hi gurus,

I would like to change the nls_date_format to 'YYYYMMDD' and the
existing server is using the values from 'SPFILE<Oracle_instance>.ORA'.
Is there any way I can modify this and moreover this is a session
variable.

This command works but this is active only for the session.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYYMMDD';

I want to change at the Oracle server level.

Thanks a lot in advance.

Regards
Rajesh






--------
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