Thursday, January 24, 2013

ORA-23404: refresh group "OWNER"."HONDA_MV" does not exist


I was getting the following message while executing the job to refresh the Matarialized view, I was trying to refresh with following statement

EXEC DBMS_REFRESH.REFRESH('HONDA_MV');
ORA-12012: error on auto execute of job 46
ORA-23404: refresh group "OWNER"."HONDA_MV" does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REFRESH", line 23
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1


The issue was fixed by using the following:

EXEC DBMS_MVIEW.REFRESH('HONDA_MV');