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.