extendeddatatypes
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.txt · Last modified: 2021/12/06 11:30 by 127.0.0.1