Oracle Error ORA-23409: could not find an unused refresh group number

Oracle Error Message

ORA-23409: could not find an unused refresh group number

Reason for the Error

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

Solution

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