Welcome to the Oracle community forum and interact with 2 million technical staff. SQLCONNECTMVADMINMVADMIN @ TESTMV is connected. SQLBEGIN2DBMS_REPCAT.CREATE_MVIEW_REPGROUP (GNAMEREP_GROUP, MASTERRAC1.US. ORACLE. COM, 3PROPAGATION_MODEASYNCHRONOUS); 4END
Welcome to the Oracle community forum and interact with 2 million technical staff> access SQL CONNECT MVADMIN/MVADMIN @ TESTMV. SQL BEGIN 2 DBMS_REPCAT.CREATE_MVIEW_REPGROUP (GNAME = 'rep _ group', MASTER = 'rac1. US. ORACLE. com', 3 PROPAGATION_MODE = 'asynchronous'); 4 END
Welcome to the Oracle community forum and interact with 2 million technical staff> enter
SQL> CONNECT MVADMIN/MVADMIN @ TESTMV is connected.
SQL> BEGIN
2 DBMS_REPCAT.CREATE_MVIEW_REPGROUP (GNAME => 'rep _ group', MASTER => 'rac1. US. ORACLE. com ',
3 PROPAGATION_MODE => 'asynchronous ');
4 END;
5/
The PL/SQL process is successfully completed.
SQL> BEGIN
2 DBMS_REFRESH.MAKE (NAME => 'yangtk. REP_REFRESH ', LIST => '', NEXT_DATE => SYSDATE,
3 INTERVAL => 'sysdate + 1/48 ', IMPLICIT_DESTROY => FALSE, ROLLBACK_SEG => '', PUSH_DEFERRED_RPC
=> FALSE,
4 REFRESH_AFTER_ERRORS => FALSE );
5 END;
6/
The PL/SQL process is successfully completed.
SQL> CREATE MATERIALIZED VIEW
2 YANGTK. T REFRESH FAST WITH PRIMARY KEY
3 as select * FROM YANGTK.T@RAC1.US.ORACLE.COM;
The materialized view has been created.
SQL> CREATE MATERIALIZED VIEW
2 YANGTK. T1 REFRESH FAST WITH PRIMARY KEY
3 as select * FROM YANGTK.T1@RAC1.US.ORACLE.COM;
The materialized view has been created.
SQL> BEGIN
2 DBMS_REPCAT.CREATE_MVIEW_REPOBJECT (GNAME => 'rep _ group', SNAME => 'yangtk ',
3 ONAME => 'T', TYPE => 'snapshot', MIN_COMMUNICATION => TRUE );
4 END;
5/
The PL/SQL process is successfully completed.
SQL> BEGIN
2 DBMS_REPCAT.CREATE_MVIEW_REPOBJECT (GNAME => 'rep _ group', SNAME => 'yangtk ',
3 ONAME => 't1', TYPE => 'snapshot', MIN_COMMUNICATION => TRUE );
4 END;
5/
The PL/SQL process is successfully completed.
SQL> BEGIN
2 DBMS_REPCAT.CREATE_MVIEW_REPOBJECT (GNAME => 'rep _ group', SNAME => 'yangtk ',
3 ONAME => 'ind _ T1_FID ', TYPE => 'index', MIN_COMMUNICATION => TRUE );
4 END;
5/
The PL/SQL process is successfully completed.
SQL> BEGIN
2 DBMS_REFRESH.ADD (NAME => 'yangtk. REP_REFRESH ',
3 LIST => 'yangtk. t', LAX => TRUE );
4 END;
5/
The PL/SQL process is successfully completed.
[1] [2] [3] [4] [5]