|
-
work around :
instead of using the name of the MV in the application. Make a view that refers to the MV.
Just before refreshing the MV, do a CTAS an make a 'temp MV table' with the contents of the MV. Change the view so it uses the table.
Rebuild the MV. Change the view so you use the MV again. Drop the 'temp MV table '.
Hope this helps
Gert
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
|