Materialized View - Transactional Refreshing

I have a materialized view, which due to the complexities, needs to be refreshed using the "complete" option (no mview log).

I noticed that the the mview appears to be empty during the refresh process (evidently due to a "truncate" being used).

Is there a way to get Oracle to make this transactional (using a delete statement), so the mview will always be usable?

I know I can do all this myself, via PL/SQL but would rather use the mview technology, if it supports it.

thanks,
--Peter Received on Thu Sep 09 2004 - 09:50:30 CDT