I am using a materialized view to get order details from a different schema. I expect my view to get refreshed every BOD. I created my Materialized view with the following code,
Code:
CREATE MATERIALIZED VIEW GetStatus_MatView
TABLESPACE V410REGIONAL
BUILD IMMEDIATE
REFRESH COMPLETE
START WITH sysdate
NEXT trunc(sysdate+1)+420/1440  
WITH PRIMARY KEY
AS 
SELECT A.OrderRef , A.OrderDate , B.OrderStatusName
...