Partition Exchange Instantaneous?
From: <japplewhite_at_austinisd.org>
Date: Wed, 22 Jun 2011 12:53:20 -0500
Message-ID: <OFD85A9C9B.F0E06B59-ON862578B7.00614E0B-862578B7.00623FFA_at_austinisd.org>
I've used Partitioned Tables and the Exchange Partition feature for years, but it's almost always been when I've got the database to myself or on a table accessed by read-only processes. I need to perform this on a table that's an Audit log for a transaction table being hit fairly frequently. The transaction table has a trigger that inserts rows in the audit table for every insert, update, or delete.
Date: Wed, 22 Jun 2011 12:53:20 -0500
Message-ID: <OFD85A9C9B.F0E06B59-ON862578B7.00614E0B-862578B7.00623FFA_at_austinisd.org>
I've used Partitioned Tables and the Exchange Partition feature for years, but it's almost always been when I've got the database to myself or on a table accessed by read-only processes. I need to perform this on a table that's an Audit log for a transaction table being hit fairly frequently. The transaction table has a trigger that inserts rows in the audit table for every insert, update, or delete.
Since the Partition Exchange is a Data Dictionary process only, I'm assuming that, should there be a DML transaction on the main table during the Exchange, the Audit row(s) will either go into the old Audit table segment or be put into the new, empty exchanged-in segment. Have there been any reports or situations where a transaction's data got "lost" during a Segment Exchange? I can't find anywhere that Oracle guarantees it won't happen.
Thanks.
Jack C. Applewhite - Database Administrator
Austin I.S.D. - MIS Department
512.414.9250 (wk) / 512.935.5929 (pager)
Sent from my old PC,
revitalized and secured by Ubuntu Linux.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 22 2011 - 12:53:20 CDT