How do you refresh Materialized Views?

[dnett]

My company recently switched from TOAD to PL/SQL Developer. We are using version 8.0.1.1502

In TOAD, I could refresh a materialized view with a single click. How do I do this in PL/SQL Developer?

 

[Marco Kalter]

There is no explicit support for this, but you can use the Browser Extender Plug-In to define any action for any object type.

 

[DavidFerrington]

Any chance of this being added to PL/SQL Developer? I too used toad to do this and we make extensive use of mviews.

In fact I've launched toad for the first time in a month because I need to refresh a lot of views.

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[bcoulam]

Please add support for refresh groups as well.

Where I currently work, we have development DBAs and physical DBAs. In general, I never need TOAD for anything since most of the system DBA work is done by the other guys. But development DBAs tend to have much to do with creating, maintaining and troubleshooting MVs and MV refresh groups.

I too would love to see this support added to PSD so I can cease needing TOAD for anything.