How To Increase The Number Of SDATA Sections To More Than 32 When Using OracleTextSearch
(Doc ID 1607548.1)
Last updated on FEBRUARY 22, 2021
Applies to:Oracle WebCenter Content - Version 220.127.116.11.0 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 18.104.22.168, as well as Oracle DB 22.214.171.124, but on a limited number of platforms.
This note explains how to use more than 32 SDATA fields with WebCenter Content.
Number of SDATA section exceeds limit(32)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|1. Increase the limit of SDATA sections on the database.|
|2. Increase the limit of SDATA sections on the Webcenter Content server|
|3. Create additional optimized fields and rebuild the index|
|How to determine how many SDATA (aka Optimized) fields are in use in the database.|