Re: Partition exchange
Date: Tue, 14 Feb 2012 16:36:54 -0600
Message-ID: <OF65C001AD.AB97B391-ON862579A4.007BD388-862579A4.007C395B_at_austinisd.org>
Kumar,
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
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
Kumar
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 14 2012 - 16:36:54 CST