How to abort an extract using event actions
Hi Folks
I have a requirement to abort the extract when sysdate is entered in the daily_job table.
For this I was simulating an extract in the following way
EXTRACT EVTEST
USERID ID GGSADMIN, PASSWORD XYZ
EXTTRAIL ./dirdat/ET
GETUPDATEBEFORES
TABLE SHEEL.GGTEST, FILTER (ID="SHEEL"), EVENTACTIONS (ABORT);
THE TABLE GGTEST IS SIMPLY (ID VARCHAR2(5), JOIN_DATE DATE).
I start the above extract then I proceed to fire the following insert in the ggtest table
SQL> INSERT INTO GGTEST VALUES ('SHEEL','01-AUG-2014');
SQL> commit;
when I check the status of the extract it's still running . It has not ABENDED or ABORTED.