Differences

This shows you the differences between two versions of the page.

--- extendeddatatypes [2015/07/28 13:48] – z0hpvk
+++ extendeddatatypes [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ===== Extended Datatypes =====
-^ Datatype   ^ Pre 12c     ^ 12c         ^
+^ Datatype   ^ Pre 12c     ^ 12c          ^
-| VARCHAR2   | 4000 bytes  | 32767 bytes |
+| VARCHAR2   | 4000 bytes  | 32767 bytes  |
-| NVARCHAR2  | 4000 bytes  | 32767 bytes |
+| NVARCHAR2  | 4000 bytes  | 32767 bytes  |
-| RAW        | 2000 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]]