I am in the process of using Data Pump to setup a copy of an Oracle database from 184.108.40.206.0 on Windows to 220.127.116.11.0 on Oracle Linux. I have had a few issues with invalid objects which I have managed to resolve but I also have a number of indexes with the domidx_opstatus of 'FAILED'.
Attempting to rebuild these indexes results in the error:
ORA-29858: error occurred in the execution of ODCIINDEXALTER routine
ORA-28031: maximum of 150 enabled roles exceeded
This is a large database that I have recently begun working on so would like to avoid removing roles from any users to avoid breaking any fuctionality.
Is there away around this or another way of fixing the indexes?