Be wary of performing domain searching while editing the underlying table. Since the domain index searches as another user in a separate connection it cannot be aware of uncommitted edits. When a row is edited and then the domain index is searched prior to a commit, that row will be searched using the incorrect structure. If a row is deleted and a search is performed prior to the commit, the row is returned as a hit will generate an Oracle internal error.

Previous topic

Similarity Ancillary Operator

Next topic