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