Hi Hendry, You can find out the process instances that have completed from BPEL_INSTANCE and match the corresponding events in BPEL_EVENT
The joining column would be probably IID in BPEL_EVENT. Just verify the joining column. You could then eliminate those events of completed process instances. regards, sathwik On Tue, Sep 24, 2013 at 6:10 PM, hbetts <[email protected]>wrote: > This only helps for v1.3 to which we have not upgraded and it does not deal > with old data. I guess the question should be "will purging the ODE_EVENT" > table have any negative impact on the rest of the system. > > Since an ERD of the ODE database does not show any foreign key constraints > on the table, I am assuming that it would not. > > Hendry > > > > -- > View this message in context: > http://apache-ode.996305.n3.nabble.com/ODE-EVENT-table-size-tp16900p16902.html > Sent from the Apache Ode User mailing list archive at Nabble.com. >
