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

Oracle - duplicate fields in RECORD,TABLE or argument list are not permitted

Oracle - ORA-29282: invalid file ID, ORA-06512: at "SYS.UTL_FILE"