All geek questions in one place

Where can I find the stop list for Oracle full-text search?

I have a client checking the full text (example below) on the new Oracle UCM website. The random text string they selected for testing was "test-only". What failed; from my testing, it seems that “only” is a reserved word, since it never returns from a full-text search (it returns from a metadata search).

I spent the morning searching for oracle.com and found this one that seems pretty comprehensive, but doesn't have a "just".

So my question is “only” a reserved word. Where can I find a complete list of reserved words for full-text search Oracle (10g)?

An example of a full text search string;

(<ftx>test only</ftx>)

Update I did some more tests. He seems to be ignoring words indicating places or times; only, some, bye, when, bye, where, there, here, nearby, this, who, roughly, this, they.

Can anyone confirm this? I cannot find this in Oracle anywhere.

Update 2. Post an answer I had to look for the words "stop", not "reserved." Updated question title and tags to reflect.
+4
source share
3 answers

I am sure the system is trying to automatically ignore common words. This explains why you cannot find "only", but "onnly" can be found. You can find "a", "an", ...

The list you gave from words that do not work looks like very common words that are often not primary words in a sentence. Given this, they are unlikely to be the words you are looking for full-text search.

What are the chances that you are looking for an article that includes the word "this" and the inclusion of this word is the only fact you have in this article?

I think I found my list ... Ironically, I started from the last company’s wiki page ..: http://www.sugarcrm.com/wiki/index.php?title=Overview_of_Full_Text_Stop_Words#Default_Stop_Words_.28for_English.29

 2.10.3 Modifying the Default Stoplist The default stoplist is always named CTXSYS.DEFAULT_STOPLIST. You can use the following procedures to modify this stoplist: • CTX_DDL.ADD_STOPWORD • CTX_DDL.REMOVE_STOPWORD • CTX_DDL.ADD_STOPTHEME • CTX_DDL.ADD_STOPCLASS When you modify CTXSYS.DEFAULT_STOPLIST with the CTX_DDL package, you must re-create your index for the changes to take effect.

List of default notes:

 a he out up be more their at had one will from it than and is only when corp not she also in says was by ms to about her over because most there has or with its that are of which could some an inc we can mz after his s been mr they have other would last the as on who for such any into were co no all if so but mrs this

Update. A good Oracle white paper that includes how full-text search works can be downloaded using: http://www.oracle.com/technology/products/text/pdf/text_techwp.pdf They mention stop words and that fact that there is a default list, but do not mention the words themselves.

Good luck

+3
source

Additional answers:

  SELECT *
 FROM DR $ STOPWORD
 LEFT JOIN DR $ STOPLIST ON DR $ STOPWORD.SPW_SPL_ID = DR $ STOPLIST.SPL_ID

In the results, the fields SPL_* are taken from the system table DR$STOPLIST , and the fields SPW_* from the table DR$STOPWORD

  • From the user schema, custom stop lists and stop words can be obtained through
  SELECT * FROM CTX_USER_STOPLISTS; 
  SELECT * FROM CTX_USER_STOPWORDS;
+4
source

Keywords are reserved: http://www.toadworld.com/KNOWLEDGE/KnowledgeXpertforOracle/tabid/648/TopicID/SQL15/Default.aspx click on "reserved keywords with keywords" on the left.

Only "Only" is in the list.

I'm not sure what happens in your case, but I can’t understand that Oracle will not support this word in full-text search only. In many cases with full text you need to search for one word. Could this be the problem you are facing?

Cheers jacob

0
source

Source: https://habr.com/ru/post/1312151/

More articles:


All Articles