Hi,
Pls refer the below query,from this query set a time interval for to process or run this query automatically in every 5 mins.
Help me...!!!
Declare
l_recid varchar2(100);
Cursor c1 is
Select a.recid from f_ac_event a,f_ac_event@abnprod b where a.recid=b.recid;
Begin
Open c1;
loop
Fetch c1 into l_recid;
Delete from f_ac_event
where recid=l_recid;
Exit when c1%notfound;
End loop;
Close c1;
End;
/
------------------------------------------------------------------------------(or)-----------------------------------------------------------------------------------------------------
delete from f_ac_event
where recid in (select x.recid from f_ac_event@abnprod x);
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
Regards,
villa