BryansGeekSpeak
Half finished documentation, scripts and other scraps from my work related projects.
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment