Help using Designer to change view

[jaburke]

Hi,
I have a universe with a view named view_mv (materialized view). I have objects created using fields from this view. I want to change (or repoint) the view from view_mv to view_vw (regular view). The columns in each of them (mv and vw) are the same. How can I do this without deleting view_mv and losing all my objects?

Thanks,
Jennifer

 

[jaburke]

I just did a 'rename table' and this seemed to work.

Thanks,
Jennifer

 

[blom0344]

In general terms this will work. You have to be careful though. The account used will have to have the same rights concerning the new object.

Ties Blom