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 

posted on 2010-06-17 20:31  蚂蚁跳楼  阅读(259)  评论(0编辑  收藏  举报