Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Please enter a title.
You can not post a blank message. Please type your message and try again.
Oracle Database + Options
This discussion is archived
on Jul 22, 2012 10:52 PM by 475694
ctx_ddl indexs - Can you add multi indexes on one table?
Jul 22, 2012 10:52 PM
I been doing a little testing with indexing the contents of URLs (database v11.2.x.x).
create index datastores_text on test_url_search ( doc ) indextype is ctxsys.context parameters ( 'Datastore TEST_URL' );
SELECT SCORE(1),DOC from TEST_URL_SEARCH WHERE CONTAINS(DOC, 'London', 1) > 0
This works. i like to more
e.g. multi words search e.g. ' London Games' where if London or games are present it return a URL with a score,
Search in the Chinese.
The only way I can see to do this is create different indexes as the attributes for 'URL_DATASTORE' are limited. If I can what does the 'Contains' statement look like?
Hope someone can point me in the right direction?
Edited by: Pete88 on Jul 22, 2012 11:52 PM
I have the same question
Show 0 Likes
This content has been marked as final.
Show 0 replies