Today I came across a situation where I need to replace the existing materialized view with the new view as the view definition was changed. I created a materialized view with the new query definition with different name and dropped the old mview. When I tried to rename the new Mview I have created I came across the following error in the Database. Oracle won’t support renaming the materialized views.
I need to explore on this one further. Meanwhile i found the error code and description in the Ora-Code site, please take a look into that.
Meet you all with further details.
No comments:
Post a Comment