6 Replies Latest reply: Jan 30, 2012 7:17 AM by Sergiusz Wolicki-Oracle RSS

    Need help on changing parameter NLS_LENGTH_SEMANTICS

    dbthought
      hi All,

      Oracle is 11.2.0.1.0

      Initially our db parameter NLS_LENGTH_SEMANTICS='CHAR' for one table I am getting error
      like

      ORA-01450: maximum key length (6398) exceeded Missing Resource String.

      I changed it NLS_LENGTH_SEMANTICS='BYTE'

      now I am able to create that table

      Is there any side effect if I am changing NLS_LENGTH_SEMANTICS from CHAR to BYTE

      like

      ALTER SYSTEM SET NLS_LENGTH_SEMANTICS='BYTE' scope=both;

      Please help me .

      Thanks In advance.