Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change NLS_NCHAR_CHARACTERSET

375214May 23 2005 — edited Jul 10 2009
HI 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2009
Added on May 23 2005
10 comments
92,956 views