Toad World® Forums

support for oracle text indexes

Does Toad 12.5 support creating Oracle text indexes? The UI for creating an index doesn’t have options for creating a text index. I looked in the help and I couldn’t find any mention of text indexes.

Example of command (taken from here)

     CREATE INDEX idx_docs ON docs(text)
INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS
('FILTER CTXSYS.NULL_FILTER SECTION GROUP CTXSYS.HTML_SECTION_GROUP');

My expectation might be off on this one.

Thanks

Yes, there is a “Domain” checkbox on the “Basic Info” tab. Once that is checked, a “Domain” tab appears where you can fill in the details.

Might be worth adding the word in parenthesis (text) as a hint since not everyone always knows that oracle feature (and many others) by their Oracle nomenclatures :slight_smile: