Oracle Remote materialized view

I. Creating a remote materialized view log

SOURCE side:

CREATE materialized VIEW LOG on Tozwdb.test tablespace tozwdb_data with ROWID;

Ii. Rights of payment

Target Library

Create user tozwdb identified by Tozwdb_dev;
Grant create session to TOZWDB;
Grant resource to tozwdb;
Grant Connect to tozwdb;
Grant Unlimited tablespace to tozwdb;
Grant CREATE database link to tozwdb;
Grant Create public database link to tozwdb;
Grant create materialized view to tozwdb;
Grant Select any table to tozwdb;
Grant CREATE table to tozwdb;

Query permissions:

SELECT * from User_sys_privs t where T.privilege like Upper ('%link% ');

Iii. creation of Db_link

Create Public Database link Db_pay connect to pay identified by pay
Using ' (Description= (address_list= (ADDRESS = (PROTOCOL = TCP) (HOST =172.16.13.25) (port=1521)))
(Connect_data = (service_name= account))) ';

Iv. creating a remote materialized view

Create materialized view tozwdb. T_IF_TOZWDB tablespace to Pay_data
Refresh fast on DEMAND with rowID START with To_date (' 08-02-2017 15:50:00 ', ' dd-mm-yyyy HH24:MI:SS ')
NEXT sysdate + 1/1440 as SELECT * from [email protected]_pay;

Oracle Remote materialized view