Re: Strange ORA-01031 Error
From: Michael Dinh <mdinh235_at_gmail.com>
Date: Tue, 6 Nov 2012 20:51:30 -0800
Message-ID: <CAENwkM6jtXvY0qtgyB-0OHoHAU+XZFAwTx9-YYDRvypTsvsXtw_at_mail.gmail.com>
Just wanted to provide an update should anyone encounter the same issue. The bug is fixed in 11.2.3.4 PSU and also interim patch available for various versions.
13080778<https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?id=13080778.8>ORA-942 / ORA-1031 / corruption for SQL using same object name in multiple schemas
Date: Tue, 6 Nov 2012 20:51:30 -0800
Message-ID: <CAENwkM6jtXvY0qtgyB-0OHoHAU+XZFAwTx9-YYDRvypTsvsXtw_at_mail.gmail.com>
Just wanted to provide an update should anyone encounter the same issue. The bug is fixed in 11.2.3.4 PSU and also interim patch available for various versions.
13080778<https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?id=13080778.8>ORA-942 / ORA-1031 / corruption for SQL using same object name in multiple schemas
On Tue, Nov 6, 2012 at 6:20 AM, Michael Dinh <mdinh235_at_gmail.com> wrote:
> Hello,
>
> I have been experiencing ORA-01031 insufficient privileges from
> application using Weblogic (WLS) connected as the schema owner.
>
> Database is 11.2.0.3 the SQL itself does not fail when execute from
> SQL*Plus and only fails when execute from the application using WLS.
>
> Restarting the database resolved the issue one time but it's reoccurring.
> Any help to identify the issue is greatly appreciated and I will be
> creating SR as well.
>
> Thanks Michael.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 07 2012 - 05:51:30 CET