Subject Re: [IBO] After Datapump with Delete, DB use leaves ib_transactions nil
Author Chuck Belanger

Found my own answer:

Inactivate triggers before deletion, then Activate them once done.

Not sure why this messed with the transaction, but it made everything work.

Actually in the process I discovered how to make the process even faster
(removing the triggers helped a lot!)--Its faster to mark the records
for deletion with the DataPump, then Delete the records that were marked.

Chuck Belanger