materialized view and archive logs
Is there a way to prevent writing archive log on a materialized view that is refreshed complete (i.e., not Fast?) without using "atomic_refresh=>FALSE" ? We cannot risk the materialized view table being empty for the several seconds it takes to complete the full refresh, which is why we are unable to use "atomic_refresh=>FALSE" . The materialized view has been created using "NOLOGGING", which appears to have had no affect on the creation of archive logs.
0