How To Increase The Number Of SDATA Sections To More Than 32 When Using OracleTextSearch (Doc ID 1607548.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle WebCenter Content - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Goal

Up to Oracle RDBMS 12c Release 1, the number of SDATA fields in an Oracle Text Index was limited to 32.  In Oracle 12c, this limit has been increased to 99.

These changes have also been backported to Oracle DB 11.2.0.4, as well as Oracle DB 11.2.0.3, but on a limited number of platforms.

This note explains how to use more than 32 SDATA fields with WebCenter Content.

Note: If this limit is not raised and you have more than 32 SDATA fields defined, you receive an error like this when you attempt to rebuild the seach collection:
Number of SDATA section exceeds limit(32)

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms