Re: ORA-00054 (alter table add partition)
From: Alex Fatkulin <afatkulin_at_gmail.com>
Date: Thu, 15 Oct 2009 15:26:40 -0400
Message-ID: <49d668000910151226k56ff1049we6d891854b5ef6c7_at_mail.gmail.com>
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.
Date: Thu, 15 Oct 2009 15:26:40 -0400
Message-ID: <49d668000910151226k56ff1049we6d891854b5ef6c7_at_mail.gmail.com>
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 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 15 2009 - 14:26:40 CDT