extendeddatatypes
This is an old revision of the document!
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).
alter system set max_string_size = EXTENDED scope=spfile; SHUTDOWN IMMEDIATE; STARTUP UPGRADE; @?/rdbms/admin/utl32k.sql SHUTDOWN IMMEDIATE; STARTUP;
Now when any extended datatype is greater than 4000 bytes it will be stored in a LOB.
extendeddatatypes.1445422736.txt.gz · Last modified: 2025/03/08 22:23 (external edit)