declare
CURSOR C_EVENT is select table_name from user_tables@DBLINK_YWKDB;
temp varchar2(100);
begin
OPEN C_EVENT;
FETCH C_EVENT into temp;
while C_EVENT%found
Loop
EXECUTE IMMEDIATE 'truncate table '||temp;
EXECUTE IMMEDIATE 'INSERT INTO '||temp||' select * from '||temp||'@DBLINK_YWKDB';
FETCH C_EVENT into temp;
End Loop;
CLOSE C_EVENT;
end;
CURSOR C_EVENT is select table_name from user_tables@DBLINK_YWKDB;
temp varchar2(100);
begin
OPEN C_EVENT;
FETCH C_EVENT into temp;
while C_EVENT%found
Loop
EXECUTE IMMEDIATE 'truncate table '||temp;
EXECUTE IMMEDIATE 'INSERT INTO '||temp||' select * from '||temp||'@DBLINK_YWKDB';
FETCH C_EVENT into temp;
End Loop;
CLOSE C_EVENT;
end;