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!

Limitations of REFRESH FAST a Materialized View

547252Aug 20 2007 — edited Aug 20 2007

The underlying SQL of a materialized view contains SYSDATE. I am not able to create the materialized view with REFRESH FAST option.
Is there any alternate method to do the same?
I tried FORCE option, but not sure if it will change the functionality of materialized view.
Any help is greatly appreciated.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 17 2007

Added on Aug 20 2007

6 comments

810 views