Database Software

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!

how to modify NLS_LANGUAGE(NLS_DATABASE_PARAMETERS's value)

TaerangNov 18 2012 — edited Nov 19 2012

my oracle database - query

SELECT VALUE FROM nls_database_parameters WHERE PARAMETER = 'NLS_LANGUAGE';

VALUE
--------------------------------------------------------------------------------
AMERICAN_AMERICA.KO16MSWIN949

i think is incorrect

profile(spfile) was modified
ALTER system SET NLS_LANGUAGE='AMERICAN' scope=spfile;

and database shutdown&startup

but, value was still "AMERICAN_AMERICA.KO16MSWIN949"

how to modify ????

Edited by: Taerang on 2012. 11. 18 오후 7:42

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 17 2012

Added on Nov 18 2012

#database-key-features, #globalization-support

8 comments

2,287 views