-
Materialized View not refreshing
Hi,
I created materialized view for complete refresh with the below syntax:
CREATE MATERIALIZED VIEW xyz_mv
TABLESPACE apps_ts_summary
NOCACHE
LOGGING
NOCOMPRESS
NOPARALLEL
BUILD IMMEDIATE
REFRESH COMPLETE
NEXT (SYSDATE + 1)
AS
....
This involves count,union all...
When I create this materialized view, it displays data but next day, this view is null.. it donot have any data..
Not sure why as I have given sysdate+1 as next refresh date
when I create the view with the below syntax
CREATE MATERIALIZED VIEW XMCI_AP_PO_SCORECARD_MV
TABLESPACE apps_ts_summary
NOCACHE
LOGGING
NOCOMPRESS
NOPARALLEL
BUILD IMMEDIATE
REFRESH COMPLETE
START WITH SYSDATE
NEXT (SYSDATE + 1)
AS
Then the view do not have any data after few seconds..
Can anybody help me out as I am totally lost here.
Thanks
Ruma
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|