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


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

select * from all_mviews;

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: