-
Analytical Function in MV
Hi All,
Can we use Analytical functions like lead, lag, etc. in FAST REFRESH Materialized Views???
Thnx in Advance
Cheers!
-
I think u can't use analytical function while creating materialized view with refresh fast option..
Wow!
Luv
Kanna
-
Tomaž
"A common mistake that people make when trying to design something completely
foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams
-
Hi Tomazz,
May i know why have u given this link?
Luv
Kanna
-
To support your opinion with documentation...
why?
Tomaž
"A common mistake that people make when trying to design something completely
foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams
-
Hi Tomazz,
Simple question.. Can we use lag function while creating materialized view with fast refresh option?
Luv
Kanna
-
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."
-
Hi Tomazz,
Simple question.. Can we use lag function while creating materialized view with fast refresh option?
Luv
Kanna
-
huh? are you reading the replies
-
Thnx for ur help guys...
No Luck still on fast refresh..... :(
Cheers!
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
|