OraFAQ Forum: Server Administration » change in nls_length

Home » RDBMS Server » Server Administration » change in nls_length_semantics parameter (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

change in nls_length_semantics parameter [message #328411]

Fri, 20 June 2008 01:47

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

Database is created with nls_length_semantics parameter as char.
I want to change nls_length_semantics parameter to byte at database level as well as session level.

Please help me.

Report message to a moderator

Re: change in nls_length_semantics parameter [message #328416 is a reply to message #328411]

Fri, 20 June 2008 02:05

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

change in init.ora
alter system
alter session

Regards
Michel

Report message to a moderator

Re: change in nls_length_semantics parameter [message #328438 is a reply to message #328416]

Fri, 20 June 2008 03:28

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

I changed init.ora, alter system, alter session then shutdown the db,started the db but it is not changing at database level and changing at session level.

SQL> select 'DATABASE:' as lvl, value
2 from nls_database_parameters
3 where parameter = 'NLS_LENGTH_SEMANTICS'
4 union
5 select 'SESSION:' as lvl, value
6 from nls_session_parameters
7 where parameter = 'NLS_LENGTH_SEMANTICS'
8 order by 1 ;

LVL VALUE
-------------------------------------------------------------
DATABASE: CHAR

SESSION: BYTE

Report message to a moderator