| MV not getting refreshed [message #61907] |
Wed, 09 June 2004 06:10 |
Sajeev
Messages: 4
Registered: May 2001
|
Junior Member |
|
|
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
