# Create Scott on MALLARD/WOMBAT
drop user scott cascade;
create user scott identified by tiger
temporary tablespace temp
default tablespace users;
grant create session to scott;
grant dba to scott;

# Create Tables on Master: MALLARD only
start demobld;
alter table emp add primary key (empno);

# DB-Link From Snapshot --> Master
WOMBAT> CREATE DATABASE LINK mallard.acs_inc.com CONNECT TO scott IDENTIFIED BY tiger using 'MALLARD';

# DB-Link From Master --> Snapshot
MALLARD> CREATE DATABASE LINK wombat.acs_inc.com CONNECT TO scott IDENTIFIED BY tiger using 'WOMBAT';

# snapshot log on Master
MALLARD>  create snapshot log on emp;
Materialized view log created.

# Snapshot on Client
desc emp@mallard.acs_inc.com;
select * from emp@mallard.acs_inc.com;

CREATE SNAPSHOT emp
 REFRESH FORCE
 START WITH SYSDATE NEXT SYSDATE+(1/1440) /* 60 SECONDS */
 AS SELECT * FROM emp@mallard.acs_inc.com;
 Materialized view created.