ORA-00054: resource busy and acquire with NOWAIT specified
I encounter this scenario back late last year when our database support teams wanted to duplicate a table and drop the corrupted original copy. This occurs when trying to acquire a table lock when the table already has one of a number of different lock present within that [...]