Changing refresh type cause ORA-23404 occasionally
(Doc ID 2665211.1)
Last updated on MAY 06, 2020
Applies to:Oracle Database - Standard Edition - Version 220.127.116.11 to 18.104.22.168 [Release 12.2]
Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 12.2]
Information in this document applies to any platform.
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
It's not necessary to change other than refresh type.
This issue occur occasionally by repeating above command.
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