Functional Indexes "Disabled"
Hello,
Today our application users reported an issue at around 10am that when they are going to save the transactions they are getting error. When we go through the application log we get the following kind of error messages reported there continously:
ORA-30554: function-based index <index_name> is disabled
When i checked the funcidx_status column of dba_indexes table the value was "DISABLED". The point is that my application was running smoothly and fine till around 10am today then how these indexes got disabled???
Please answer me in following points:
1. What are the possible reasons of the indexes' disabled?
2. How I can get the information about who worked on this?
and other questions regarding "audit point of view" although audit feature is not being used.
However, I have changed the status of indexes to enable and everything goes fine. But need help from you experts to find the cause of the issue.
Regards,