Dear Friends ,
I a create materialized views on oracle 11g (11.2.0.3) using below way :
a) Create Materialized view :
CREATE MATERIALIZED VIEW tab1_MV
BUILD IMMEDIATE
REFRESH FORCE ON DEMAND
AS select * FROM tab1@REMOTEDB ;
CREATE MATERIALIZED VIEW tab2_MV
BUILD IMMEDIATE
REFRESH FORCE ON DEMAND
AS select * FROM tab2@REMOTEDB ;
2) create refresh for 5 sec :
BEGIN
DBMS_REFRESH.make(
name => 'MINUTE_REFRESH',
list => '',
next_date => SYSDATE,
interval => '/*5:Sec*/ SYSDATE + 5/(60*24*60)',
implicit_destroy => FALSE,
lax => FALSE,
job => 0,
rollback_seg => NULL,
push_deferred_rpc => TRUE,
refresh_after_errors => TRUE,
purge_option => NULL,
parallelism => NULL,
heap_size => NULL);
END;
/
3) Add table :
BEGIN
DBMS_REFRESH.add(
name => 'MINUTE_REFRESH',
list => 'tab1_MV',
lax => TRUE);
END;
/
Now Friends , when I add a single table then refresh is happening every 5 sec successfully . But when I add two tables (or, above one table) then refresh is not happening every 5 sec . It makes happen with few delays . I dont find out the problem .
If anybody experience such type of problems then please help me .