oracle dblink 存储过程 插入大量数据方法

需要插入数据的表名先新建个表 (sq,table_name)

注意内容:     t_sql := 'insert into ' || c.table_name ||  '  select * from ' || c.table_name || '@dblink';

其中 ||  '  select 内容 || ' select   中‘号与select 之前有空格。

create or replace procedure p_insert_gps(a in number, b in number) is
  t_sql varchar2(2000);
begin
  for c in (select table_name from gps_insert
             where sq >= a
               and sq <= b) loop
    t_sql := 'insert into ' || c.table_name ||  '  select * from ' || c.table_name || '@dblink';
     execute immediate t_sql;
    commit;
  end loop;
end p_insert_gps;