Change NLS_NCHAR_CHARACTERSET
375214May 23 2005 — edited Jul 10 2009HI all,
I need to change following NLS_NCHAR_CHARACTERSET parameter in database B and make it same as database A. Is this possible to change and how ?? We are using oracle 9.2.0.5 on Sunsolaris.
Database A:
SQL> select * from nls_database_parameters where parameter='NLS_NCHAR_CHARACTERSET';
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_NCHAR_CHARACTERSET AL16UTF16
Database B:
SQL> select * from nls_database_parameters where parameter='NLS_NCHAR_CHARACTERSET';
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_NCHAR_CHARACTERSET US7ASCII
Thanks