===== Extended Datatypes =====

^ Datatype   ^ Pre 12c     ^ 12c          ^
| VARCHAR2   | 4000 bytes  | 32767 bytes  |
| NVARCHAR2  | 4000 bytes  | 32767 bytes  |
| RAW        | 2000 bytes  | 32767 bytes  |

Parameter MAX_STRING_SIZE (Default is STANDARD).\\
<code>alter system set max_string_size = EXTENDED scope=spfile;
SHUTDOWN IMMEDIATE;
STARTUP UPGRADE;
@?/rdbms/admin/utl32k.sql
SHUTDOWN IMMEDIATE;
STARTUP;</code>

Now when any extended datatype is greater than 4000 bytes it will be stored in a LOB.\\

[[https://oracle-base.com/articles/12c/extended-data-types-12cR1|Oracle Base Article]]