ORA-00054: resource busy and acquire with NOWAIT specified

Problem Description

In my production database Oracle 10.2g while I was adding column to one of my transaction table it fails with ORA-54 error as below.



SQL> alter table student add b number;

alter table student add b number

*

ERROR at line 1:

ORA-00054: resource busy and acquire with NOWAIT specified