Anyone knows, how to change DATABASE_VALUE to CHAR? my database is running on 12cr2 version. it have mistakenly created to BYTE.
I've manage to change NLS_LENGTH_SEMANTICS to CHAR by altering it.
I know DATABASE_VALUE parameter is set when we create the database, but just curious to know is that possible to change it ? or do i need to drop database and recreate back with CHAR instead of BYTE.
Or this is fine, can i ignore DATABASE_VALUE and proceed with this value?
initial parameter:
PARAMETER
--------------------------------------------------------------------------------
DATABASE_VALUE
--------------------------------------------------------------------------------
SESSION_VALUE
--------------------------------------------------------------------------------
INSTANCE_VALUE
--------------------------------------------------------------------------------
NLS_LENGTH_SEMANTICS
BYTE
BYTE
BYTE
After try: alter system set nls_length_semantics='CHAR' scope=both;
PARAMETER
--------------------------------------------------------------------------------
DATABASE_VALUE
--------------------------------------------------------------------------------
SESSION_VALUE
--------------------------------------------------------------------------------
INSTANCE_VALUE
--------------------------------------------------------------------------------
NLS_LENGTH_SEMANTICS
BYTE
CHAR
CHAR