DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, July 6, 2017

ORA-12048: error encountered while refreshing materialized view

ORA-12034: materialized view log on "<USERNAME>"."<Table Name>" younger than last refresh

Analysis

1.The first Check the all the materialized view details on database.

select * from all_mviews;

               OR
select * from dba_mviews;


2. Find same materialized view and materialized view log created in to some another user.
In my case i have same materialized view created on under the SYS user.


3. Drop the materialized view and materialized view log on the both users and recreate materialized view and materialized view log under the required user.

drop materialized view log on <Log Name>;
create materialized view log on <Log Name>;
create materialized view MVNAME build immediate refresh fast on demand as select * from OBJECTNAME;


No comments: