Database Administration (MOSC)

MOSC Banner

Is there any explaination from an NLS expert for this?

edited Jun 15, 2018 10:59AM in Database Administration (MOSC) 2 commentsAnswered
database was created nls_length_semantics = char  
instance is nls_length_semantics = char
 
session is nls_length_semantics = byte
 
 
this has cause some columns to revert back to byte ..
 
SQL> select  * from nls_database_parameters where parameter='NLS_LENGTH_SEMANTICS' 
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_LENGTH_SEMANTICS
CHAR
 1* select  * from nls_database_parameters where parameter='NLS_LENGTH_SEMANTICS' 
 
 
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_LENGTH_SEMANTICS
CHAR
 
 
SQL>  select  * from nls_session_parameters where parameter='NLS_LENGTH_SEMANTICS'    
PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_LENGTH_SEMANTICS
BYTE

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center