oracle 停止搜索,全文搜索 – 在哪里可以找到Oracle全文搜索的“停止”单词列表？...

我打赌系统试图自动忽略经常出现的单词.这可以解释为什么你找不到’只’但是’onnly’可以找到.你能搜索’a’,’an’,……

你给出的不起作用的单词列表看起来像一些非常常见的单词,通常不是句子中的主要单词.鉴于此,它们不太可能是您在全文搜索中搜索的单词.

您正在寻找包含“那个”这个词的文章的几率是多少,并且包含该词是您在文章中唯一的事实？

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.

默认禁用词列表：

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

更新 – 来自Oracle的一份很好的白皮书,其中包括全文搜索的工作方式,可以从以下网址下载：http://www.oracle.com/technology/products/text/pdf/text_techwp.pdf.他们提到了停用词和存在默认列表的事实,但是没有提到单词本身.