Oracle 12c 启用VARCHAR2, NVARCHAR2, and RAW类型支持32K(4,000 to 32,767 bytes)

12c新特性部分 Increased Size Limit for VARCHAR2, NVARCHAR2, and RAW Data Types
官方如下介绍：
The maximum size of the VARCHAR2, NVARCHAR2, and RAW data types has been increased from 4,000 to 32,767 bytes.
Increasing the allotted size for these data types allows users to store more information in character data types 
before switching to large objects (LOBs). This is especially useful for brief textual data types and 
the capabilities to build indexes on these types of columns.


a.默认情况下varchar2长度不能超过4000 
b.插入varchar2超过4000的字段(列长度为4000),自动被截断 


Oracle 12C支持字符串32K处理过程 
1.修改MAX_STRING_SIZE=’EXTENDED’ 
2.重启数据库至upgrade状态 
3.执行@?/rdbms/admin/utl32k.sql 
4.重启数据库至正常open状态

eg:

#############################################################################################

C:\Users\Administrator>sqlplus sys/thisris#2016824@10.1.11.212:1523/hyris as sys
dba


SQL*Plus: Release 11.2.0.1.0 Production on 星期三 8月 24 14:55:07 2016


Copyright (c) 1982, 2010, Oracle.  All rights reserved.




连接到:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt
ions

SQL> show parameter MAX_STRING_SIZE

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------