ORA-23404: refresh group "string"."string" does not exist

Cause : A refresh group name was given that is not in sys.rgroup$.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Provide a refresh group name that is in sys.rgroup$ or dbs_rgroup.

update : 25-04-2017

ORA-23404 - refresh group "string"."string" does not exist
ORA-23404 - refresh group "string"."string" does not exist

  • ora-19279 : XQuery dynamic type mismatch: expected singleton sequence - got multi-item sequence
  • ora-25141 : invalid EXTENT MANAGEMENT clause
  • ora-14121 : MODIFY DEFAULT ATTRIBUTES may not be combined with other operations
  • ora-12710 : CREATE CONTROLFILE character set is not known
  • ora-30678 : too many open connections
  • ora-24344 : success with compilation error
  • ora-01951 : ROLE 'string' not granted to 'string'
  • ora-15186 : ASMLIB error function = [string], error = [string], mesg = [string]
  • ora-12211 : TNS:needs PREFERRED_CMANAGERS entry in TNSNAV.ORA
  • ora-01934 : circular role grant detected
  • ora-00310 : archived log contains sequence string; sequence string required
  • ora-31666 : Master process string had an unhandled exception.
  • ora-28110 : policy function or package string.string has error
  • ora-19956 : database should have no offline immediate datafiles
  • ora-30489 : Cannot have more than one rollup/cube expression list
  • ora-14044 : only one partition may be moved
  • ora-07682 : sou2os: set kernel dispatch fail err
  • ora-38105 : Delete not yet supported when Update row-migration is possible
  • ora-30968 : invalid XPATH or NAMESPACE option for XML Index
  • ora-07405 : sptrap: cannot setup alternate signal stack.
  • ora-31452 : invalid value string for parameter, expecting: Y or N
  • ora-31093 : null or invalid value specified for parameter : string
  • ora-19510 : failed to set size of string blocks for file "string" (blocksize=string)
  • ora-28039 : cannot validate Kerberos service ticket
  • ora-29546 : badly formed resource: string
  • ora-19854 : error obtaining connect string from target
  • ora-13376 : invalid type name specified for layer_gtype parameter
  • ora-19649 : offline-range record recid string stamp string not found in file string
  • ora-19633 : control file record string is out of sync with recovery catalog
  • ora-24236 : source text is empty
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.