Hi I am new here, I am trying to simulate materialized view running on Oracle 11gR1 on top of windows OS. I want to include sysdate in the query of my materialized view on a fast refresh but i kept on having the error saying that oracle is seeing that may query is a complex query and not supported by the fast refresh of materialized view. Is there any work around that i can do? I need to simply select * from the master table then include sysdate column in it. Thank you!