The status of the materialized view with 30 million records is ‘UNUSABLE’, so a complete refresh is required to fix this problem .
The complete refresh process ran for 3 hours, then we have to kill it.
SQL> execute dbms_mview.refresh(MVIEW1','c'); ^C^C ^C^C^C^C^C^C^C BEGIN dbms_mview.refresh('MVIEW1','c'); END; * ERROR at line 1: ORA-12152: TNS:unable to send break message Elapsed: 03:11:16.16
There are a couple of following ways to speed up this complete refresh, one of them only takes 27 minutes.
Subscribe to get access
Read more of this content when you subscribe today.