Xref: alice comp.databases.oracle.server:19963
Path: alice!news-feed.fnsi.net!news.idt.net!news-peer.gip.net!news.gsl.net!gip.net!xfer.kren.ne.kr!xfer.kren.nm.kr!newsfeed.dacom.co.kr!not-for-mail
From: ktlim <ktlim@lgtel.co.kr>
Newsgroups: comp.databases.oracle.server
Subject: Re: Help Completely Baffled
Date: Thu, 30 Apr 1998 17:30:26 +0900
Organization: csbs
Lines: 32
Message-ID: <354836A2.F5C9E045@lgtel.co.kr>
References: <893579946.24665.0.nnrp-11.c2de082b@news.demon.co.uk>
Reply-To: ktlim@lgtel.co.kr
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.01 [en] (Win95; I)
X-Priority: 3 (Normal)

jk wrote:

> I've tried to set the nls_date_format to 'DD-MON-YYYY' in the
> initorcl.ORA file
> (Oracle 7.2.2) and it seems to be ignored what am I doing wrong.
>
> If I look at the parameter file then it tells me that nls_date_format
> = 'DD-MON
> YYYY' however selecting sysdate from dual always returns the 9
> character date
> format.
>
> Alter session to set nls_date_format always works fine.
>
> How do I get the instance to recognise this new format or can't I.
>
> Please anyone help if you can i'm completely baffled here.
>
> John

   John,
Did you restart oracle after you changed your initSID.oar file?
then,
I think you have to check shell script file.
if you use csh , then check .cshrc
and if you use sh,ksh, then check .profile.
generally, this file has oracle environment  variables.
example, NLS_LANGUAGE, NLS_DATE_FORMAT etc.
you have to change this environment variable.

good luck!