While creating an index or doing DDL change on a table, getting resource busy error.

 

PROBLEM:

SQL> create index IND_TEST on DBATEST ( OBJECT_ID);
create index IND_TEST on DBATEST ( OBJECT_ID)
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

 

Solution:

There are some other sessions which are blocking this sessions

1. Check for locked_objects

We can see, there is an exclusive lock on the table.
Kill the session, to release the lock

Now re-run the create index statement,