We are experimenting with materialized views and have run into problems with redo logs being generated when doing a refresh force on demand. Certain proposals have been made, such as to change the ATOMIC_REFRESH on the refresh statement. What syntax would you use to do this and can this be done per materialized view?
The materialized view is refreshed every 30 seconds and we don't want the refresh interval to change. A fast refresh can't be used - we get a ORA-12015: cannot create a fast refresh mv from a complex query error. Have looked into using NOLOGGING but there are various articles saying that this doesn't stop redo log creation.
Does anyone have any other suggestions?