Subject | Re: [IBO] After Datapump with Delete, DB use leaves ib_transactions nil |
---|---|
Author | Chuck Belanger |
Post date | 2008-03-15T06:25:21Z |
Hello:
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
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