-
Fast Refresh of MV not working
I have a function based index on a base table of a materialized view. With the fb-index, it will only do a complete refresh. Remove the fb-index and wha-la, fast refreshing.
I'm guessing that this is yet another limitation of materialized views .. but perhaps someone has a workaround or I'm just not doing something right.
Your thoughts?
-
It sounds like you've got the issue all-identified, and it sounds like the kind of thing that's entirely believable.
Do you get an error message, or are you using FORCE and you always get a complete refresh?
-
OK, found the bug. It's an 8.1.7.3 issue fixed in 8.1.7.4
I appreciate your reply slimdave.
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
|