I build web apps with a bunch of different frameworks (.NET MVC, SharePoint, Drupal, ColdFusion) using bunch of different datastores (Oracle, SQL Server, MySQL, some CouchDB). I'm also a big fan of continuous integration testing and devops.

Refresh a Materialized View in Oracle

less than 1 minute read

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 >_<;)

Tags:

Updated:

You May Also Enjoy

Node.js web app experiments

1 minute read

Needed a break from all the .NET and Coldfusion goo I’ve been dealing with at work. Started working on a mobile-first workout tracking app using only free to...