Changing refresh type cause ORA-23404 occasionally
(Doc ID 2665211.1)
Last updated on JULY 20, 2024
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 |