Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Is that possible to change DATABASE_VALUE=CHAR ?

M.DilipkumarAug 15 2018 — edited Aug 29 2018

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

This post has been answered by Gaz in Oz on Aug 17 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 26 2018
Added on Aug 15 2018
3 comments
11,894 views