My Oracle Support Banner

unable to search with long string value in Memo type field extended optimized text type field (Doc ID 1900099.1)

Last updated on MARCH 22, 2022

Applies to:

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


In WCC env using OracleTextSearch(OTS), you may face following problems if you change type of an "Optimized" Text or Long Text type field to Memo type.
(This issue does not occur in newly created Memo field.)


The issue occurs after you change type of a field which meets all of following 2 conditions to "Memo", then collection rebuild(*).

(*)Note: If you have not rebuilded search index or did it by "fast rebuild", you face <Note:1560366.1> issue. In other words, this issue remains even after fixing <Note:1560366.1> by doing collection rebuild.)



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.