Home » RDBMS Server » Server Administration » change in nls_length_semantics parameter (10g)
change in nls_length_semantics parameter [message #328411] Fri, 20 June 2008 01:47 Go to next message
grpatwari
Messages: 257
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.
Re: change in nls_length_semantics parameter [message #328416 is a reply to message #328411] Fri, 20 June 2008 02:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
change in init.ora
alter system
alter session

Regards
Michel
Re: change in nls_length_semantics parameter [message #328438 is a reply to message #328416] Fri, 20 June 2008 03:28 Go to previous messageGo to next message
grpatwari
Messages: 257
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
Re: change in nls_length_semantics parameter [message #328455 is a reply to message #328438] Fri, 20 June 2008 04:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database is meaningless, it just say what was at database creation time, see instance view.

Regards
Michel
Re: change in nls_length_semantics parameter [message #328462 is a reply to message #328455] Fri, 20 June 2008 04:47 Go to previous message
grpatwari
Messages: 257
Registered: June 2008
Location: Hyderabad
Senior Member
Thanks Michel..

In instance view it is view.
Previous Topic: Last Modified Date
Next Topic: Oracle Data Block
Goto Forum:
  


Current Time: Sat Dec 10 18:29:11 CST 2016

Total time taken to generate the page: 0.09422 seconds