I followed the instructions to change the max string size parameter from standard to extended. I am using 12.2.
SQL> show parameter max_string_size;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_string_size string EXTENDED
I can create a table
create table sys.testing (col1 number, col2 varchar2(32000)); without issues.
However if I create a new schema and try to create the table for the schema I get ORA-00910.
CREATE USER CISADM IDENTIFIED BY WwellCcooMmee13 DEFAULT TABLESPACE CISTS_01 TEMPORARY TABLESPACE TEMP;
create table cisadm.testing (col1 number, col2 varchar2(32000)); Fails.
Please advise.