9.2.0.4 - Is there a way to create a materialized view initally empty? The reason is, we are doing a migration from one db to another - we need to recreate all the MV's for one reason or another and some of the ones that get refreshed weekly are big. We'd like to create them empty so we can compile the code, then wait for the weekly jobs to kick in and refresh them - I cant see any clauses that make it possible?
The only way I can think of is to create s dummy schema with empty objects that the MV's are built on, create private syns for these, create the MV's, drop the private syn's then run the refresh jobs when required to refresh the data?
Any other ideas would be welcome!