Last updated on September 24th, 2019 at 05:35 pmORA-00054: resource busy and acquire with NOWAIT specified is a common error seen in Oracle Database Reference: Oracle documentation This generally happens when you try to execute a DDL on the table which is locked by transaction .It also happens if  select for update statement is executed with NOWAIT option Example SQL> alter table emp add (middlename varchar2(15)); … Continue reading ORA-00054: resource busy and acquire with NOWAIT specified »