8 Replies Latest reply: Nov 19, 2012 2:34 PM by Sergiusz Wolicki-Oracle RSS

    how to modify NLS_LANGUAGE(NLS_DATABASE_PARAMETERS's value)

    Taerang
      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