Partition exchange
From: Kumar Madduri <ksmadduri_at_gmail.com>
Date: Tue, 14 Feb 2012 12:40:23 -0800
Message-ID: <CAHDOOG5z-scqyoQWVoaR2qSLoa3QZ7T028zUYEgQkuZqfjVLwg_at_mail.gmail.com>
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."
Date: Tue, 14 Feb 2012 12:40:23 -0800
Message-ID: <CAHDOOG5z-scqyoQWVoaR2qSLoa3QZ7T028zUYEgQkuZqfjVLwg_at_mail.gmail.com>
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-lReceived on Tue Feb 14 2012 - 14:40:23 CST