LIQUENT InSight 6.2 Installation Guide

Oracle Configuration Update

The following Oracle configuration upgrade must be performed on your database server before migrating any data and before installing LIQUENT InSight 6.2.

Please note the following descriptions and settings when performing the Oracle configuration update:

  • MAX_STRING_SIZE controls the maximum size of VARCHAR2, NVARCHAR2, and RAW data types in SQL.
  • STANDARD means that the length limits for Oracle Database releases prior to Oracle Database 12c apply (for example, 4000 bytes for VARCHAR2 and NVARCHAR2, and 2000 bytes for RAW).
  • EXTENDED means that the 32767 byte limit introduced in Oracle Database 12c applies.
  • The COMPATIBLE initialization parameter must be set to 12.0.0.0 or higher to set MAX_STRING_SIZE = EXTENDED.
  • You can change the value of MAX_STRING_SIZE from STANDARD to EXTENDED. However, you cannot change the value of MAX_STRING_SIZE from EXTENDED to STANDARD.