Re: ORA-00054 (alter table add partition)
- From: DBA Deepak <oracle.tutorials@xxxxxxxxx>
- To: Alex Fatkulin <afatkulin@xxxxxxxxx>
- Date: Fri, 16 Oct 2009 20:21:43 +0530
Alex,
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@xxxxxxxxx> 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@xxxxxxxxx>
> 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
Other related posts:
