Re: Partition exchange

From: <>
Date: Tue, 14 Feb 2012 16:36:54 -0600
Message-ID: <>

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 <> To: oracle Freelists <> Date: 02/14/2012 02:41 PM

Subject:        Partition exchange
Sent by:

In an ebiz environment, we have hit ora-8103 for a particular plsql program
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 wf_user_roles.
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).

Thank you


-- Received on Tue Feb 14 2012 - 16:36:54 CST

Original text of this message