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 ?