Top 60 Oracle Blogs

Recent comments

April 2015

OakTable World at IOUG COLLABORATE15

class="l-submain-h g-html i-cf">

size="-2">Update history: /> 5-Apr: WIT panel added, Alex removed, Gwen and Pete schedule shifted. /> 11-Apr: Gwen and Pete swapped sessions. /> 13-Apr: Jonathan off lightning talks. />

Guess what? OakTable World at IOUG C15 is happening again! Last year, we had awesome sessions and wonderful attendees. The sessions were so successful, in fact, that we needed a bigger room this year (there were other reasons too, but hey we can fit more people now!).

What: OakTable World C15 /> When: Wednesday, April 15, 2015, 8:00am – 5:30pm /> Where: Mandalay Ballroom K /> id="more-72835">

Oracle 12c SQL – Expanded VARCHAR2 (32k)

Extended VARCHAR2

Oracle 12c now allows an expanded maximum size for VARCHAR2, NVARCHAR2, and RAW columns; CHAR and NCHAR are unchanged.
Three varying character datatypes may now grow to a maximum size of 32,767 bytes (4,000 was the previous limit):

  • VARCHAR2       32767
  • NVARCHAR2    16383
  • RAW                    32767

Expanded VARCHAR is not the default; it must be enabled by DBAs (see following).

Extended VARCHAR Setup

DBA activities to setup extended VARCHAR include:

  • Set init parameter:  max_sql_string_size = EXTENDED
  • May be set when creating database
  • To change an existing database
  • Bring database to UPGRADE mode first
  • Execute upgrade script (utl32k.sql)

Once made, the change to extended is irreversible!

Using Extended VARCHAR

Extending VARCHAR maximum size should be researched carefully:

OT: New Oracle Database features spell doom and gloom for NoSQL

Oracle Corporation has released a slew of new features that allow Oracle Database implementations to catch up to, match up to, and leave in the dust NoSQL implementations in the areas of performance, scalability, and reliability (PSR).(read more)

OT: Oracle wants your votes

It used to be that if you had an enhancement suggestion for Oracle Database, you had to file an enhancement request in MOS and pray that the Oracle product management gods would hear your request someday. It is now possible to make your enhancement request in a public forum and let the community vote on your idea.(read more)