My Oracle Support Banner

Frequently Asked Questions for Oracle Text (Doc ID 153264.1)

Last updated on JUNE 01, 2023

Applies to:

Oracle Text - Version 9.2.0.1 to 12.2.0.1 [Release 9.2 to 12.2]
Information in this document applies to any platform.

Purpose

This note attempts to list the frequently asked questions regarding Text administration.

Questions and Answers

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
Purpose
Questions and Answers
 What is Oracle Text?
 Can you enumerate the main features of Oracle Text?
 What is the official Web page for Oracle Text?
 What's the official documentation for Oracle Text?
 What is the difference between ConText and Oracle Text?
 How do you determine what version of Oracle Text you are running?
 Are there any books on Oracle Text?
 How do you manually install Oracle Text?
 How do I check my Text installation and setup?
 How do you configure Oracle Text with an existing database using Database Configuration Assistant (DBCA)?
 Does Text work with Replication?
 Can you partition an text index?
 Does Text work with Real Application Cluster(RAC)?
 How do you tune a Text Query?
 How do you empty CTX_INDEX_ERRORS view?
 How do you drop an index that is in FAILED or LOADING state?
 Should I use CTX_DDL or ALTER INDEX to maintain my index?
 Can you query an text index during the optimization process?
 Does Oracle Text create theme indexes by default?
 What does "ABOUT" mean in a query?
 Where can I find working code samples?
 My index creation seemed to succeed, but my searches don't find any information. Why not?
 What are Document Services?
 What are the Filters used by Oracle Text?
 Can I Build Indexes on XML Attribute Values?
 Can I Create a Text Index on More Than One Column?
 How Fast is Text at Indexing?
 How do I increase the score for a document?
 The CTXSYS account is locked. How do I unlock the account?
 ORA-28575: unable to open RPC connection to external procedure agent while using CTX_DOC.IFILTER 
 Create index error: ORA-00955: name is already used by an existing object
References

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