Set max_strings_size to extended
Here is using 12.2 database and would like to set the max_string_size to extended.
during the setting . there is a warning
Index "OWNERNAME"."INDEX_NAME" must be dropped because it now exceeds maximum key length.
The index is a single column index on a table. which the column is varchar2(4000 char)
what's the problem on this ?. MAX string size successfully changed to EXTENDED.
Database charset is UTF8
tablespace blocksize is 8K