Materialized view + DB link

BARRYDB

• user: barry
• table: t
• db-link: to_tpktst

TPKTST

• user: flash
• db-link: to_barry

BARRYDB side

barry

create materialized view log on mv_test with rowid including new values;

TPKTST side

sysdba

flash 

Job

example

1.
create table t(
  id   varchar2(30),
  name varchar2(30)
);

2.
create or replace procedure proce_t is
begin
  insert into t(id, name) values('1', to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss'));
   commit;
end proce_t;
/

3.
declare
job number;
begin
  sys.dbms_job.submit(job => job,
                      what => 'proce_t;',
                      next_date => to_date('02-05-2017 13:15:00', 'dd-mm-yyyy hh24:mi:ss'),
                      interval => 'sysdate+1/24/60');
  commit;
end;
/

4.
select job, next_date, next_sec, failures, broken from user_jobs;