Re: Partition exchange
Date: Tue, 14 Feb 2012 16:36:54 -0600
Look at DBA_Objects.Created and Last_DDL_Time for that Partition and see if either or both were during the time of interest. That would at least confirm or deny that a DDL operation occurred. If Created was during the time, I'd bet on a Partition Exchange, though I don't have a table handy that I can check.
Jack C. Applewhite - Database Administrator
Austin I.S.D. - MIS Department
512.414.9250 (wk) / 512.935.5929 (pager)
From: Kumar Madduri <ksmadduri_at_gmail.com> To: oracle Freelists <Oracle-L_at_freelists.org> Date: 02/14/2012 02:41 PM
Subject: Partition exchange Sent by: oracle-l-bounce_at_freelists.org
In an ebiz environment, we have hit ora-8103 for a particular plsql
and while debugging it, I found note 1326404.1. The note says this "This problem is caused by the underlying partitioning exchange, which can lead to change in the ROWID for the records in any of the queried tables."
I think the tables involved are wf_user_role_assignments and
How do I know if a partition exchange has been done at the time the custom plsql program run? This was not done manually by us (partition exchange).
http://www.freelists.org/webpage/oracle-l Received on Tue Feb 14 2012 - 16:36:54 CST