Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
#database-key-features, #globalization-support
3 comments
12,188 views