GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

How to abort an extract using event actions

edited Aug 12, 2014 5:02AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center