All your view and function creation statements should be in scripts that
you maintain as a kind of best practice. If you've done that, then you can
simply drop/cascade the view you're replacing after you renamed it and then
rebuild the rest of them.
I actually go one step further and put the view
Robert James wrote:
> I have a view which is very slow to computer, but doesn't change often.
>
> I'd like to materialize it. I thought I'd do a simple poor man's
> materialize by:
>
> 1) ALTER VIEW myview RENAME to _myview
> 2) SELECT * INTO myview FROM _myview
>
> The only problem is that all m
