Re: ORA-00054 (alter table add partition)

From: Alex Fatkulin <>
Date: Thu, 15 Oct 2009 15:26:40 -0400
Message-ID: <>

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 <> wrote:
> The application uses "alter table ... add partition..." to add the
> partitions

Alex Fatkulin,
Received on Thu Oct 15 2009 - 14:26:40 CDT

Original text of this message