Batch refresh remote materialized view (standby)

Batch refresh remote materialized view (standby) 1. create a remote database connection create database link MDM connect to MDM identified by mdm using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = 172.17.11.1) (PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SID = MDM) '; 2. Create two materialized views: create materialized view departmenttablespace DAT_ICNFUSING INDEXTABLESPACE IDX_ICNFREFRESH force on demandasselect * from mdm. DEPARTMENT @ mdm where treelevel = 1 and status = '0'; create materialized view employeetablespace DAT_ICNFUSING INDEXTABLESPACE IDX_ICNFREFRESH force on demandasselect * from mdm. EMPLOYEE @ mdm where status = '0'; 3. Create a refresh Group execute DBMS_REFRESH.MAKE (NAME => 'mvtag', LIST => 'department, employe', NEXT_DATE => SYSDATE, INTERVAL => '/* 24: HR */SYSDATE + 5/(60*24)'); commit; 4. Delete the refresh group -- execute dbms_refresh.destroy ('mvtag '); -- commit; source http://www.cnblogs.com/downmoon/archive/2013/04/09/3010768.html