Database Administration (MOSC)

MOSC Banner

Changing NLS_LENGTH_SEMANTICS from BYTE to CHAR in 19c CDB/PDB

Hi all,

I am needing to change the NLS_LENGTH_SEMANTICS from BYTE to CHAR in 19c. The databases are already AL32UTF8/AL16UTF16. The databases do utilize Oracle Text.

I saw the article for older systems; Examples and limits of BYTE and CHAR semantics usage (NLS_LENGTH_SEMANTICS) (Doc ID 144808.1) but it also says not to used this script past version 12.2. But the DMU tool doesn't look like what I need.

I know I'll need to alter system for the change to CHAR. Had Oracle Text changed to where I DON'T need to drop and recreate indexes? Still tempted to use script provided for the older version as that seems to make sense for what I need.

Tagged:

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