Thank you very much for the co-operation. It is working by the
following command :

ALTER SYSTEM SET NLS_DATE_FORMAT = 'YYYYMMDD' SCOPE=SPFILE;

And then restart the server.

Cheers
Rajesh

-----Original Message-----
From: sanjay
[mailto:oracledba-ezmlmshield-x39047180.[Email address protected]
Sent: Wednesday, August 04, 2004 1:49 PM
To: LazyDBA Discussion
Subject: RE: Oracle startup parameters -reg


NLS_DATE_FORMAT can be specified with the Initialisation
parameter,Environ variables ( at client side) or dynamic with the means
of Alter session ( can`t set with alter system)..
you can override it in the TO_ functions, also

Sunjay Khangarot

-----Original Message-----
From: Chethan Anand N.
[mailto:oracledba-ezmlmshield-x68071615.[Email address protected]
Sent: Wednesday, August 04, 2004 11:10 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





Confidentiality Notice

The information contained in this electronic message and any attachments
to this message are intended
for the exclusive use of the addressee(s) and may contain confidential
or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or
[Email address protected] immediately
and destroy all copies of this message and any attachments.


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