While truncating the table I am getting the following message:
SQL> truncate table one_col;
truncate table one_col
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
this is because table one_col is being used by another un committed DML statement in another session. Example:
SQL> insert into one_col (name) values('harvey');
1 row created.
Once the insert is committed or rolled back then we will be able to do any DML operation from another session.
