Oracle Solution for Error ora-23409

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

What triggered the Error:

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

What should we do to fix it:

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