Changing refresh type cause ORA-23404 occasionally
(Doc ID 2665211.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Standard Edition - Version 126.96.36.199 to 188.8.131.52 [Release 12.2]
Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [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