What I want to do is provide a search web page where a user can enter text terms and get results from hits in my database.
I want the query to run against fields in tables that I define.
I want the query to run against dozens of fields located in about 100 tables inside a single tablespace.
I want the results to indicate the table, field, and record where the hit came from.
I think that OracleText only runs queries against one or more fields in a SINGLE table. I want to run against multiple fields in multiple tables.