insert into table_des
select * from table_src ts
where table_src.LogTime>(select Max(LogTime) From table_des)
select * from table_src ts
where table_src.LogTime>(select Max(LogTime) From table_des)
create trigger tri_rep
after insert
on table_src
for each row
begin
insert into table_des values(:new.logtime,:new.usertype) ;
end;
/
实现即时的复制
SQL> create or replace procedure pro
2 is
3 begin
4 insert into aa values(1,sysdate);
5 end;
6 /Procedure createdQL> declare
2 jobno number;
3 begin
4 dbms_job.submit(jobno,'pro;',sysdate,'sysdate+1/(24*60)');
5 commit;
6 end;
7 /
以上是一个定时复制
也可以使用触发器,自动插入
create trigger tri_rep
before insert on table_src
for each row
a date;
begin
select max(logtime) into a from table_src;
if :new.logtime>a then
insert into table_des values(:new.logtime,:new.usertype) ;
end if;
end;
/