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

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'),

Comments

Popular posts from this blog

Hibernate - HibernateException: createQuery is not valid without active transaction