Questions tagged [oracle-text]

a tool for building text query applications and document classification applications on top of Oracle databases. Oracle Text provides indexing, word and theme searching, as well as highlighting capabilities for text.

What questions should have this tag?

All questions referencing Oracle indexes:

  • CONTEXT
  • CTXCAT
  • CTXRULE
  • CTXPATH

or Oracle query operators that rely on those indexes:

  • CONTAINS
  • CATSEARCH
  • MATCHES

Definitions

Text Query Applications

The purpose of a text query application is to enable users to find text that contains one or more search terms in a collection of documents such as plain text, HTML, XML, or Microsoft Word. It requires either a CONTEXT or CTXCAT index, which can be queried using CONTAINS or CATSEARCH operators respectively.

Document Classification Applications

A document classification application is one that classifies an incoming stream of documents based on its content. For example, an online news agency might need to classify its incoming stream of articles as they arrive into categories such as politics, crime, and sports.

This scenario requires a CTXRULE index. This index indexes the rules (queries) that define each class. When documents arrive, the MATCHES operator can be used to match each document with the rules that select it.

Important links for learning more

123 questions
29
votes
3 answers

Does Oracle support full text search?

Is there an Oracle equivalent to MS SQL's full text search service? If so, has anyone implemented it and had good / bad experiences?
JosephStyons
  • 57,317
  • 63
  • 160
  • 234
26
votes
1 answer

Oracle text escaping with curly braces and wildcards

I want to be able to escape the search criteria in an Oracle text query using contains and combine the escaped criteria with wildcards to have "doubly truncated" criteria. (I know my indexes may not be setup for ideal performance, but that is…
Necreaux
  • 9,451
  • 7
  • 26
  • 43
12
votes
1 answer

Suggestions for Querying Database for Names

I have an Oracle database that, like many, has a table containing biographical information. On which, I would like to search by name in a "natural" way. The table has forename and surname fields and, currently, I am using something like this: select…
Xophmeister
  • 8,884
  • 4
  • 44
  • 87
11
votes
4 answers

Oracle: Full text search with condition

I've created an Oracle Text index like the following: create index my_idx on my_table (text) indextype is ctxsys.context; And I can then do the following: select * from my_table where contains(text, '%blah%') > 0; But lets say we have a have…
Clinton
  • 22,361
  • 15
  • 67
  • 163
11
votes
3 answers

How to sync and optimize an Oracle Text index?

We want to use a ctxsys.context index type for full text search. But I was quite surprised, that an index of this type is not automatically updated. We have 3 million documents with about 10k updates/inserts/deletes per day. What are your…
trunkc
  • 6,223
  • 4
  • 34
  • 49
7
votes
1 answer

Set up Oracle Text to index values of multiple columns in Oracle tables

I have a set of Oracle tables that describe information about property owners. Owner names and other text values are stored in multiple fields in multiple related tables, for each owner. I would like to index the contents of these fields. My goal is…
JoshL
  • 10,737
  • 11
  • 55
  • 61
6
votes
3 answers

Oracle Text Criteria Query in JPA

Is it possible to perform a JPA Criteria Query using Oracle Text's contains statement, and if so how?
Ryan
  • 7,499
  • 9
  • 52
  • 61
5
votes
1 answer

oracle text definescore with accum and Query rewriting

I am using Oracle text to search in a corpus of sentences I want the scoring to be as counting the discrete occurrences only, Example : My Query is ( dog cat table ) If it found the term " dog " it must count 1 even if the sentence has more than…
4
votes
4 answers

not able to drop and recreate the oracle text index

I am not able to drop and recreate the oracle text index. SQL> drop index "WBR"."CTX_t1"; Index dropped SQL> SQL> CREATE INDEX "WBR"."CTX_t1" 2 ON WBR.t1(ASSET_XML) 3 INDEXTYPE IS "CTXSYS"."CONTEXT" 4 PARAMETERS ('DATASTORE…
Prashant Mishra
  • 619
  • 9
  • 25
4
votes
1 answer

Oracle text: strange behaviour of score function

I've got a strange behaviour on a German surname "Warsoenke". Check this out: create table test_warsoe as select 'Mister Warsoenke ABC-12' name from dual; create index test_warsoe_index on test_warsoe(name) indextype is ctxsys.context; select…
smnbbrv
  • 23,502
  • 9
  • 78
  • 109
3
votes
0 answers

Oracle Text catsearch left-truncated search

So according to The oracle documentation on catsearch it's not possible to use left-truncated searches with a catsearch text-query. However, I've found that using double wildcards does have the desired effect of left-truncated queries. E.g. select *…
3
votes
2 answers

How to get around 4000 characters limitation of text_query in Oracle's CONTAINS operator?

In Oracle, the full text search syntax of Contains operator is: CONTAINS( [schema.]column, text_query VARCHAR2 [,label NUMBER]) RETURN NUMBER; which means the text_query can not be more than 4000 characters…
hko19
  • 1,054
  • 4
  • 16
  • 25
3
votes
3 answers

Oracle Text: How to sanitize user input

If anyone has experience using Oracle text (CTXSYS.CONTEXT), I'm wondering how to handle user input when the user wants to search for names that may contain an apostrophe. Escaping the ' seems to work in some cases, but not for 's at the end of the…
chris
  • 36,094
  • 53
  • 157
  • 237
2
votes
1 answer

CONTAINS doesn't work with Oracle Text

I am having an issue executing this query. SELECT * FROM gob_attachment WHERE CONTAINS (gob_a_document, 'java') > 0 It's giving me ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: Oracle Text error: ORA-00942: table or view does…
Petr Mensik
  • 26,874
  • 17
  • 90
  • 115
2
votes
1 answer

Oracle Text multi column index based query does not return any rows

I have a MAH_KERESES_MV table with 3 columns OBJEKTUM_NEV, KERESES_SZOVEG_1, KERESES_SZOVEG_2. I create the following multi column Oracle Text index: exec ctx_ddl.create_preference( 'MAH_SEARCH', 'MULTI_COLUMN_DATASTORE'); exec…
user1054310
  • 171
  • 1
  • 4
  • 11
1
2 3
8 9