Workaround for ORA-23404: refresh group %s.%s does not exist (Doc ID 1578678.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 12.1.0.1 [Release 10.2 to 12.1]
Information in this document applies to any platform.

Goal

Error: ORA-23404: refresh group %s.%s does not exist

What the Oracle documentation says:

Error:    ORA-23404
Text:    refresh group %s . %s does not exist
---------------------------------------------------------------------------
Cause:    A refresh group name was given that is not in SYS.RGROUP$.
Action:    Provide a refresh group name that is in SYS.RGROUP$ or DBS_RGROUP.

So, it assumes that refresh group name should be present in SYS.RGROUP$.

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms