My Oracle Support Banner

Changing refresh type cause ORA-23404 occasionally (Doc ID 2665211.1)

Last updated on MAY 06, 2020

Applies to:

Oracle Database - Standard Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Oracle Database - Enterprise Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Information in this document applies to any platform.

Symptoms

Create mview and execute repeatedly these command to change refresh type.

 

   ALTER MATERIALIZED VIEW REFRESH FAST START WITH SYSDATE NEXT...

   ALTER MATERIALIZED VIEW REFRESH ON DEMAND

 

Then occasionally below errors are recoreded to alert.log.

 

ORA-12012: error on auto execute of job <JOB_NAME>

ORA-23404: refresh group "<OWNER>"."<REFRESH_GROUP>" doesn't exist.

ORA-06512: "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: "SYS.DBMS_IREFRESH", line 1017

ORA-06512: "SYS.DBMS_REFRESH", line 17

ORA-06512: "SYS.DBMS_REFRESH", line 214

ORA-06512: line 1



Changes

 It's not necessary to change other than refresh type.

This issue occur occasionally by repeating above command.

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.