Materialized view not refreshing

0
votes

I have the following scenario:

I have created 2 tables in custom schema in 11.5.10. I have created a materialized view in a new schema(not apps) in 11.5.9 joining the 2 tables in 11.5.10

I have used following syntax for creating a MV

CREATE MATERIALIZED VIEW <new_schema>.xx_sample_testing_mv 
REFRESH NEXT SYSDATE+1/1440
as 
select...........

When I add new records to the 2 tables materialized view is not getting refreshed. When I create materialized view only on a single table its getting refreshed, but not when I use more than one table.

1
oraclematerialized-views

1 Answers

0
votes

You should check the following points:

  • You specified refresh period as 1 minutes(1/1440 day = 1 min). Is the materialized view refreshed after 1 minute?
  • Try to execute the select part and it is finished running in 1 minute.