How To Increase The Number Of SDATA Sections To More Than 32 When Using OracleTextSearch

(Doc ID 1607548.1)

Last updated on FEBRUARY 02, 2018

Applies to:

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


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, as well as Oracle DB, 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)



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