SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

alter materialized view is taking a long time

526272Dec 7 2007 — edited Dec 7 2007

I have a MV with refresh option as REFRESH FAST ON DEMAND START WITH sysdate+0 NEXT SYSDATE+5/1440

I want to alter it as under:
ALTER MATERIALIZED VIEW mv_name REFRESH NEXT SYSDATE+(5/24*60);

The alter command has been running since 10 mnts. Does it take so long to refresh? I have around 41,000 records in it. Please advise.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 4 2008

Added on Dec 7 2007

2 comments

467 views