先获取大量表的名称GPS_HT_%，要导入的数据内容格式一样。

再用过程导入数据，'insert into  '||c.tname||' select * from gps_ht_0';

create or replace procedure p_insert_gps_ht(a in number,b in number) is

  t_sql varchar2(2000);
begin
  for c in (select tname
              from (select rownum sq, tname
                      from tab
                     where tname like 'GPS_HT_%'
                     order by tname)
             where sq >= a
               and sq <= b) loop
 t_sql:='insert into  '||c.tname||' select * from gps_ht_0';
    execute immediate t_sql;
    commit;
  end loop;
end p_insert_gps_ht;