Oracle DB_LINK

디비 전체 테이블 삭제

Begin
   for c in (select table_name from user_tables) loop
  execute immediate ('drop table '||c.table_name||' cascade constraints');
end loop;
  End;

디비링크 테이블 복사

Begin
   for c in (select table_name from user_tables@TEST) loop
      execute immediate ('CREATE TABLE '||c.table_name||' AS SELECT * FROM '||c.table_name||'@TEST WHERE 1=2  ');
  end loop;
End;

디비링크 테이블 데이터 복사

Begin
   for c in (select table_name from user_tables@TEST) loop
      execute immediate ('INSERT INTO'||c.table_name||' AS SELECT * FROM '||c.table_name||'@TEST   ');
  end loop;
End;