max_string_size determines the maximal length of varchar2 that can be stored in tables. STANDARD, the maximum length is 4000, otherwise 32767. max_string_size is set to STANDARD, will throw ORA-00910: specified length too long for its datatype: create table tq84_max_string_size( txt varchar2(4001) );