select 'create table hfmis.' || table_name || ' as select * from ' || table_name || '@link1;' from
(select table_name from user_tables@link1
minus
select table_name from all_tables where owner = 'HFMIS')
oracle查找于dblink远程数据库表不一致并创建补齐表及数据
select 'create table hfmis.' || table_name || ' as select * from ' || table_name || '@link1;' from
(select table_name from user_tables@link1
minus
select table_name from all_tables where owner = 'HFMIS')
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
