Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Alter table add partition return ORA-00054

615123Oct 7 2010 — edited Oct 7 2010

hi,

i have Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production installed on Red Hat Enterprise Linux Server release 5.4 (Tikanga).

i am adding a partition in to table after each two minutes as per business requirement, while doing it i am getting.

< ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired />

I know this is due to table is locked for previous partition addition. if i am not wrong. is there any document or link which proves this.

Or this is an bug, issue

Please help me to resolve this.

Thanks
umesh

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 4 2010

Added on Oct 7 2010

#general-database-discussions

1 comment

731 views