This content has been marked as final. Show 4 replies
The Error comes when An attempt was made to access a function-based index that has been marked disabled because the function on which the index depends has been changed.
You can check the index status from below queries
select owner, index_name, status, domidx_status, domidx_opstatus,funcidx_status from dba_indexes where domidx_opstatus is not null;
Rebuilding the index is solution for this
You can refer to note id 958746.1 and 560202.1 for more details.
I am not able to able to locate this doc note id 958746.1 and 560202.1
Please send the link or this doc.
PLEASE DO NOT POST NEW ITEMS TO A 2+ YEAR OLD THREAD.. IF YOU NEED TO ASK A QUESTION LIKE THIS, START A NEW THREAD AND ASK YOUR QUESTION THERE...