Extended Data Types
Last updated
Last updated
Beginning with Oracle Database 12_c_, you can specify a maximum size of 32767 bytes for the
VARCHAR2,NVARCHAR2, andRAWdata types. You can control whether your database supports this new maximum size by setting the initialization parameterMAX_STRING_SIZE.A
VARCHAR2orNVARCHAR2data type with a declared size of greater than 4000 bytes, or aRAWdata type with a declared size of greater than 2000 bytes, is an extended data type. ().
Oracle allows increasing the database max string size from STANDARD to EXTENDED, however, Snowflake does not contain an equivalent for this functionality.
Therefore VARCHAR2, NVARCHAR2 and RAW extended Data Types are not supported in Snowflake, and they are transformed just as regular VARCHAR2, NVARCHAR2, and RAW data types. Check and for more information.
ALTER SYSTEM SET MAX_STRING_SIZE='EXTENDED';
Is not being parsed by SnowConvert.
No related EWIs.