Tomaz already gave you the simple answer. Did you read the link he posted?
"Materialized views are not eligible for fast refresh if the defining query contains an analytic function."
|
Results 1 to 10 of 18
Thread: Analytical Function in MVThreaded View
|
Click Here to Expand Forum to Full Width |