Daryl, that's so good to hear (now everybody is gonna bug you with intermedia questions). Checkout /openacs-4/packages/search/sql/postgresql/search-sc-create.sql
You might want to checkout the openfts-driver which provides an implementation (for openfts) of the contract found in the referenced file.
Basically, you need to provide seven tcl functions that include:
* search, index, unindex, summarize (context of search terms -- not so important), or update the index for an item
* provide information for the driver
I'm not very familiar with oracle but AFAICS you might need these tcl functions to maintain an auxiliary table so that you can batch process them say every hour or so by using intermedia's api.
Hope that helps.