This discussion is archived
8 Replies Latest reply: Nov 19, 2012 12:34 PM by Sergiusz Wolicki (Oracle) RSS

how to modify NLS_LANGUAGE(NLS_DATABASE_PARAMETERS's value)

685216 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points