Forum OpenACS Q&A: Response to How do I build search capabilities into a new application?
Daryl, I don't know if this is what you're looking for (you need to sign in):
* (Oracle Intermedia) http://otn.oracle.com/docs/products/intermedia/content.html
* (Oracle Text) http://download-east.oracle.com/otndoc/oracle9i/901_doc/text.901/a90122/toc.htm
Note that Oracle intermedia utilizes inverted index which is very fast for searching but not as fast for online indexing. In loose terms the inverted index requires that every searchable item is reindexed every time you need to update one of the indexed document.OpenFTS is much superior in that respect which makes it very good for web apps.