Oracle建表（A库到B库）

select \’drop table \’ || t.TABLE_NAME || \’;\’ col1,\’create table \’ || t.TABLE_NAME ||
       \’ as select * from \’ || t.TABLE_NAME || \’@db_link_84;\’ col2
  from all_tables@db_link_84 t
 where t.OWNER = \’JHHMS\’
   and t.TABLE_NAME like \’QUALITY%\’