Monday, May 10, 2010

Refresh a Materialized View in Oracle

To refresh an oracle materialized view, run the following command:
execute DBMS_SNAPSHOT.REFRESH( 'MV','C');
where "MV" is the view name

(this is a re-post - trying to get it to show up in google search >_<;)

No comments: