RE: ORA-00054 (alter table add partition)
- From: "Sylvester, Peter A." <peters@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 19 Oct 2009 17:39:05 -0400
If you google "ORA-00054" you will certainly see lots of possibilities.
I found that DDL intensive apps (especially with partition maintenance) seem to
be prone to seemingly random ORA-00054 errors.
I eventually put all DDL commands through a retry loop that catches the 54
error and waits a second and reruns it.
Generally it always seems to work on the second try.
I suspect that it is due to some kind of internal data dictionary locking.
This is using 10.2 on Linux x64.
--Peter
Other related posts: