Is there an Oracle equivalent to MS SQL's full text search service?
If so, has anyone implemented it and had good / bad experiences?
+11
A:
Oracle Text is the equivalent functionality.
I've had good experiences with it. Assuming that you are maintaining the text index asynchronously, that tends to be the first source of problems, since it may be a bit between a change being made and the index getting updated, but that's normally quite reasonable during normal operation.
Justin Cave
2008-10-14 20:22:20
We found Oracle's update of the index to be vastly superior to SQL Servers. SQLServer 2005, the indexing is a separate app that you have to manually invoke.
gbjbaanb
2010-07-29 18:06:45
+1
A:
And further to what Justin said, it is possible to create the index so it updates on commit, although this is not recommended for large amounts of text.
It offers much more power than a simple LIKE compare against %string%.
chris
2008-10-20 18:41:11
A:
Yeh, but MS SQL offers FORMSOF, INFLECTIONAL, CONTAINS, FREETEXT and easy work like this Fulltext search manager
Michal Jezek
2010-02-11 17:14:15