Clicky

ORACLE - ORA-12008: error in materialized view refresh path ORA-01476: divisor is equal to zero

January 27, 2014

**Problem: **

begin dbms_mview.refresh(‘MY_VIEW’,‘C’); end; 

ORA-12008: error in materialized view refresh path ORA-01476: divisor is equal to zero

create or replace MY_VIEW(F_FIELD_1, 

(…),

F_CREATED_BY, F_CREATED_ON, F_UPDATED_BY, F_UPDATED_ON)
as
select

(…)
CREATED_DATE, 

to_date(CREATED_BY, ‘DD/MM/YYYY’),
UPDATEDD_DATE,  

to_date(UPDATED_BY, ‘DD/MM/YYYY’), 

  from

(…)

;

Caused by:

to_date(CREATED_BY, ‘DD/MM/YYYY’), 

to_date(UPDATED_BY, ‘DD/MM/YYYY’),