Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: NLS_DATE_FORMAT on server - 8.1.5

Re: NLS_DATE_FORMAT on server - 8.1.5

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/05/15
Message-ID: <958410343.5807.0.pluto.d4ee154e@news.demon.nl>#1/1

svrmgr is a client tool, it responds to the registry key nls_date_format *ONLY*. Sounds like Tech Support needs
a) a better bug database
b) some serious bashing

Lol

Sybrand Bakker, Oracle DBA

TurkBear <johng_at_mm.com> schreef in berichtnieuws 392023d3.10868618_at_news.news-ituk.to...
> I just updated by server ( Netware) to Oracle 8.1.5 and, after a few
 hiccups,
> all went well; I cannot, however, seen to set the NLS_DATE_FORMAT for the
> database...
>
> Mt init<sid>.ora file ( the one in the pfile directory called by the one
 in the
> database directory ) has
> NLS_DATE_FORMAT = "DD-MON-YYYY"
>
> Yet when I do a select sysdate from dual ( at the console with svrmgr31) I
 get
> 15-MAY-00
>
> I removed, at Oracle Tech's suggestion, all NLS_ references in the
 config.ora
> file, but It didn't help...
>
>
> any Ideas ?
>
> Thanks,
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
Received on Mon May 15 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US