Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Building index from multiple tables for text search

494363Feb 28 2006 — edited Jun 8 2006
Hallo,

I had a look at how to build a index table to optimize search with Oracle text.
At the moment we are using a JOIN of tables to search for a text in several fields located in different tables.

My question is:

Is it possible to create that index table from several tables?
If yes, can you point me out to any links or give me an example.

So far, all the examples I read were about 1 table only.

Thanks

Elisabeth
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 6 2006
Added on Feb 28 2006
12 comments
17,708 views