How to reduce number of archive log files generated by refreshing Materialized views

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: How to reduce number of archive log files generated by refreshing Materialized views







Solution:



1. alter MV to nologging
ALTER MATERIALIZED VIEW NAME NOLOGGING;

2. alter index on it
alter index name rebuild nologging;

3. set nocompress
ALTER MATERIALIZED VIEW Name NOCOMPRESS;

4. Set ATOMIC_REFRESH=>FALSE
exec DBMS_MVIEW.REFRESH('DOTTK_ADM.CHS_REPLICA1_MV','C',ATOMIC_REFRESH=>FALSE);

Get Oracle Certifications for all Exams
Free Online Exams.com