Database Administration (MOSC)

MOSC Banner

Is that possible to set NLS_LENGTH_SEMANTICS = CHAR permanently on CBD ?

In a single environment, I edited the P file, created the SP file, and was able to make change using ALTER SYSTEM command. To check, I created a table and checked with this command.

SELECT COLUMN_NAME, CHAR_LENGTH, CHAR_USED FROM USER_TAB_COLUMNS WHERE TABLE_NAME = 'TEST_TABLE';

Now I have tried the same thing on CBD environment but not sure if it worked because I have not used CBD environment before.

My question is, Is that possible to set NLS_LENGTH_SEMANTICS = CHAR permanently on CBD ? and how ?

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