Hi Chethan,

Actually this parameter cannot be set with alter system command.

Regards

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


-----Original Message-----
From: Chethan Anand N.
[mailto:oracledba-ezmlmshield-x68071615.[Email address protected]
Sent: Wednesday, August 04, 2004 1:40 AM
To: LazyDBA Discussion
Subject: RE: Oracle startup parameters -reg

try this
ALTER SYSTEM SET NLS_DATE_FORMAT = 'YYYYMMDD' scope=spfile;

ALTER SYSTEM SET NLS_DATE_FORMAT = 'YYYYMMDD' scope=both;(both pfile and
spfile)

Orasupport
-----Original Message-----
From: KANCHIS RAJESH
[mailto:oracledba-ezmlmshield-x41189162.[Email address protected]
Sent: Wednesday, August 04, 2004 11:04 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
*********************************************************************
Disclaimer: The information in this e-mail and any attachments is
confidential / privileged. It is intended solely for the addressee or
addressees. If you are not the addressee indicated in this message, you may
not copy or deliver this message to anyone. In such case, you should destroy
this message and kindly notify the sender by reply email. Please advise
immediately if you or your employer does not consent to Internet email for
messages of this kind.
*********************************************************************


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