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