This discussion is archived
6 Replies Latest reply: Jan 30, 2012 5:17 AM by Sergiusz Wolicki (Oracle) RSS

Need help on changing parameter NLS_LENGTH_SEMANTICS

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

Legend

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