Oracle Error Codes

could not find an unused refresh group number

1000 consecutive refresh group numbers, as defined by the rgroupseq number, were already used by rows in sys.rgroup$.

How to Solve :

Alter the sequence number to be within a legal unused range and destroy unneeded refresh groups.