Change NLS LANG

classic Classic list List threaded Threaded
2 messages Options
big
Reply | Threaded
Open this post in threaded view
|

Change NLS LANG

big
Hi,
On 19c, ON AIX how to Change CDB from :
 NLS_LANG : AMERICAN_AMERICA.AL32UTF8
To:
NLS_LANG : AMERICAN_AMERICA.WE8ISO8859P1

Thanks.
Reply | Threaded
Open this post in threaded view
|

Re: Change NLS LANG

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