31.3 Upgrading Tables With JSON Data For Use With the In-Memory Column Store

A table with JSON columns created using a database that did not have a compatibility setting of at least 12.2 or did not have max_string_size = extended must first be upgraded, before it can be populated into the In-Memory Column Store (IM column store). To do this, run script rdbms/admin/utlimcjson.sql.

Script rdbms/admin/utlimcjson.sql upgrades all existing tables that have JSON columns so they can be populated into the IM column store. To use it, all of the following must be true:

  • Database parameter compatible must be set to 12.2.0.0 or higher.

  • Database parameter max_string_size must be set to extended.

  • The JSON columns being upgraded must be known to contain well-formed JSON data. This is the case for a column of data type JSONFoot 1 or a non-JSON type column that has an is json check constraint defined on it.

Related Topics

Parent topic: In-Memory JSON Data


Footnote Legend

Footnote 1: Database initialization parameter compatible must be at least 20 to use data type JSON.