Re: ORA-00054 (alter table add partition)

Thanks for the help. Just wanted to understand what could be the reason for such issues? I tried setting the parameter as suggested to failed to keep track of the lock as the duration is too less.

On Fri, Oct 16, 2009 at 12:56 AM, Alex Fatkulin <afatkulin_at_gmail.com> wrote:

> What you can do it set ddl_lock_timeout to a non-zero value, that
> would make the session to be blocked for the time specified instead of
> immediately failing with ora-54. While it remains blocked take a look
> at v$lock at the "offending" other transaction that holds you up. That
> may give you some clues.
>
> On Thu, Oct 15, 2009 at 2:29 PM, DBA Deepak <oracle.tutorials_at_gmail.com>
> wrote:
> > The application uses "alter table ... add partition..." to add the
> > partitions
> >
>
> --
> Alex Fatkulin,
> http://afatkulin.blogspot.com
> http://www.linkedin.com/in/alexfatkulin
>

-- 
Regards,

Deepak
Oracle DBA

--
http://www.freelists.org/webpage/oracle-l