master site:
alibaba>create table tmp(a int primary key);

Table created.

alibaba>CREATE MATERIALIZED VIEW LOG ON alibaba.tmp
2 /

Materialized view log created.

alibaba>column object_name format a30
alibaba>select object_name,object_type,owner from dba_objects where object_name like 'MLOG$%';

OBJECT_NAME OBJECT_TYPE OWNER
------------------------------ ------------------ ------------------------------
MLOG$_TMP TABLE ALIBABA

target site:
SQL> CREATE DATABASE LINK lk_ora CONNECT TO alibaba IDENTIFIED BY xxx USING 'ORA1';

数据库链接已创建。

SQL> Create table tmp as select * from ;

表已创建。

SQL> Create materialized view mv_tmp on prebuilt table REFRESH FAST START WITH SYSDATE NEXT sysdate+1/24/60
2 as
3 Select a From
4 /

实体化视图已创建。

SQL> column object_name format a30
SQL> select object_name,object_type from user_objects where object_name='TMP';

OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------------------------
TMP TABLE
TMP MATERIALIZED VIEW

master site:
alibaba>insert into tmp values(1);

1 row created.

alibaba>commit;

Commit complete.

alibaba>insert into tmp values(2);

1 row created.

alibaba>commit;

Commit complete.

target site:
过一分钟
SQL> select * from tmp;

A
----------
1
2

SQL> drop materialized view tmp;

实体化视图已删除。

SQL> select object_name,object_type from user_objects where object_name='TMP';

OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------------------------
TMP TABLE

SQL> select * from tmp;

A
----------
1
2