Text token lookup
673975Jul 22 2009 — edited Jul 29 2009Hello,
I'm trying to figure out how to look up all of the tokens that the text index extracted from a specific text. I see the DR$<INDEX>$I table, DR$<INDEX>$K tables, but how do I use those and the source table to find all of the tokens extracted from a specific entry in the source table?
To expand a little more and maybe clarify:
I have used the CTXSYS.CTX_DOC.TOKENS procedure and obtained the list of tokens that that returns for the specific record, but I'm trying to see what the index currently contains.
The problem I'm trying to track down is that a search for a certain term returned an incorrect number of results. So I took one of the id's that it didn't return to try and track down why it isn't returning it. I have triple, quadruple, quintuple checked the text field and it does contain the search term with no random characters before, after, or inside of the term. The CTXSYS.CTX_DOC.TOKENS call tokenizes the text and searching those results, the search term is there. So I'm trying to track down if it's actually in the text index properly or not.
Edited by: KevinD on Jul 22, 2009 12:05 PM