Re: A question about ORA-00054
From: Thomas Day <tomdaytwo_at_gmail.com>
Date: Thu, 24 Mar 2011 09:11:35 -0400
Message-ID: <AANLkTikyO-Xes8ghiXZcVV+SWOu_yHUqjrL7ePgA6XHd_at_mail.gmail.com>
Live and learn. New with Oracle 11. However, this will still result in an ORA-00054, only quicker. I'm not sure that it will resolve the situation since the original (unconnected) server session isn't the one with the ddl_lock issue. It's problem is that it can't connect to its client. You still need to kill that session on the server.
Date: Thu, 24 Mar 2011 09:11:35 -0400
Message-ID: <AANLkTikyO-Xes8ghiXZcVV+SWOu_yHUqjrL7ePgA6XHd_at_mail.gmail.com>
Live and learn. New with Oracle 11. However, this will still result in an ORA-00054, only quicker. I'm not sure that it will resolve the situation since the original (unconnected) server session isn't the one with the ddl_lock issue. It's problem is that it can't connect to its client. You still need to kill that session on the server.
On Wed, Mar 23, 2011 at 12:17 PM, Taral Desai <taral.desai_at_gmail.com> wrote:
> *
> *
> alter sesion set ddl_lock_timeout
>
> On Tue, Mar 22, 2011 at 8:26 PM, Mani <manips2002_at_gmail.com> wrote:
>
>> ORA-00054
>
>
>
>
> --
> Thanks & Regards,
> Taral Desai
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 24 2011 - 08:11:35 CDT