Where can I find a list of 'Stop' words for Oracle fulltext search?

Posted by Tyronomo on Stack Overflow See other posts from Stack Overflow or by Tyronomo
Published on 2010-06-08T02:36:22Z Indexed on 2010/06/08 23:32 UTC
Read the original article Hit count: 344

I've a client testing the full text (example below) search on a new Oracle UCM site. The random text string they chose to test was 'test only'. Which failed; from my testing it seems 'only' is a reserved word, as it is never returned from a full text search (it is returned from metadata searches).

I've spent the morning searching oracle.com and found this which seems pretty comprehensive, yet does not have 'only'.

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

Full text search string example;

(<ftx>test only</ftx>)


Update. I have done some more testing. Seems it ignores words that indicate places or times; only, some, until, when, while, where, there, here, near, that, who, about, this, them.

Can anyone confirm this? I can't find this in on Oracle anywhere.


Update 2. Post Answer I should have been looking for 'stop' words not 'reserved'. Updated the question title and tags to reflect.

© Stack Overflow or respective owner

Related posts about full-text-search

Related posts about reserved-words