oracle 不同資料庫表複製建立

1.涉及到不同網路之間的 視圖/表/

2.所以，其實有些項目不應該建立多個資料庫連結的

 

select *from tab_sbzt@dblink_fssj

create table scott.lc_sbzt as select *from tab_sbzt@dblink_fssj;

select *from lc_sbzt;

create table scott.lc_lsxxcx as select *From tab_lsxxcx@dblink_fssj where rownum<460;

select *from lc_lsxxcx;

create table scott.jj_sbzt as select *From atmssd.tab_sbzt@dblink_jj

create table scott.jj_sbzt as select *From lc_sbzt

truncate table jj_sbzt

select *From jj_sbzt

insert into jj_sbzt select *from atmssd.tab_sbzt@dblink_jj

select *From atmssd.tab_ssxxcx@dblink_jj where rownum<500

create table scott.jj_ssxxcx as select *from lc_lsxxcx

truncate table jj_ssxxcx

insert into jj_ssxxcx (select *from atmssd.tab_ssxxcx@dblink_jj where rownum<500)

select *From jj_ssxxcx