Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: NLS Database Parameters vs. NLS Instance Parameters
Craig & Co. wrote:
> "Michel Cadot" <micadot{at}altern{dot}org> wrote in message
> news:41b3effc$0$32761$626a14ce_at_news.free.fr...
>
>>"Craig & Co." <crb_at_amsa.gov.au> a écrit dans le message de >>news:41b3ddd9$0$29529$c30e37c6_at_ken-reader.news.telstra.net... >> >>>Hi, >>> >>>What is the difference between NLS_DATABASE_PARAMETERS >>>and NLS_INSTANCE_PARAMETERS? >>> >>>Craig. >>>-- >> >>"NLS_DATABASE_PARAMETERS lists permanent NLS parameters of the database." >>That is set at the database creation. >>"NLS_INSTANCE_PARAMETERS lists NLS parameters of the instance." >>That is set by the init.ora or spfile (or alter system command for a few
>>Regards >>Michel Cadot >>
You must also consider NLS parameters set at the session level.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96529/ch3.htm#49267
-- Mark Bole http://www.bincomputing.comReceived on Mon Dec 06 2004 - 20:01:15 CST
![]() |
![]() |