Re: ORA-00054 (alter table add partition)
Date: Fri, 16 Oct 2009 16:57:13 +0200
> When we start our application for the first time creates 100 range
> partitions with 10 hash subpartitions for a table.
> We have observed that only 90 partitions are getting created and for
> remaining partitions we are getting "ORA-00054 : resource busy and
> acquire with NOWAIT specified" exceptions.
may be a problem with dml_locks parameter not large enough (i.e. 900) ?
kfReceived on Fri Oct 16 2009 - 09:57:13 CDT