Materialized view not getting refreshed
Hi,
I've created a Mview which is not getting rereshed. I would like to refresh it every hour. It is a compled MV with a union and uses a view in join.
The MV is
CREATE MATERIALIZED VIEW trn_dependent_mv
REFRESH NEXT SYSDATE + 1/24 AS
SELECT
elg.txn_id TRAN_SEQ,
dep.chg_reason REASON
FROM dependent dep,
transaction elg,
user_vw uv
WHERE elg.txn_id=dep.txn_id
AND uv.gessouid = elg.gessouid
UNION
SELECT
elg.txn_id TRAN_SEQ ,
dep.chg_reason REASON
FROM dependent dep,
transaction_tv elg,
user_vw uv
WHERE elg.txn_id=dep.txn_id
AND uv.uid = elg.uid;
Any problems in it?
