My Oracle Support Banner

Troubleshooting OracleTextSearch in UCM 10g and 11g: How to Convert UCM Searches into SQL Queries (Doc ID 1333414.1)

Last updated on NOVEMBER 14, 2022

Applies to:

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

Goal

When using OracleTextSearch as the full text search solution (SearchIndexerEngineName=OracleTextSearch), is it possible to run the searches as queries against the UCM database?

Solution

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
Goal
Solution
 System Audit Information - Trace Sections and Server Output
 Manually Querying the IdcText Tables in 10g and 11g
 How to manually run CONTENT_SEARCH.SEARCH_WITH_RESULTSETINTERFACE
 Note: On when doing a full repository search.
 Note: On when doing a quick search
 How to manually run CTX_QUERY.RESULT_SET
 Still have questions?

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