Re: Change NLS LANG

Posted by ErmanArslansOracleBlog on Mar 06, 2023; 8:51am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Change-NLS-LANG-tp11698p11700.html

Please see ->

The Priority of NLS Parameters Explained (Where To Define NLS Parameters) (Doc ID 241047.1)

-->There is no way to change these after the database creation (except the NLS_(NCHAR)_CHARACTERSET).

But you can overwrite it by setting it in instance level or session level..

-->
NLS_INSTANCE_PARAMETERS and NLS_SESSION_PARAMETERS take precedence. So, if you have an application that requires that a certain NLS setting need to be set "on database level" and it is seen in NLS_INSTANCE_PARAMETERS then that's ok, even if the value in NLS_DATABASE_PARAMETERS is different.

some other indirectly related MOS notes ->

NLS_LANGUAGE Not Same In PDB$SEED As In CDB (Doc ID 2698738.1)