Oracle modify table name encountered "ORA-00054: resource is busy, but are speci

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

To modify the table name Oracle 11g:

rename ASSETPORJECT to ASSETPROJECT;

Results: ORA-00054: resource is busy, but are specified in the NOWAIT access to resources, or a timeout failure.

It seems there are locking the table conversation, then, the following query:

SELECT sid, serial#, username, osuser FROM v$session where sid 
in(select session_id from v$locked_object);
--Kill off a related conversation
ALTER SYSTEM KILL SESSION '597,1171';

To execute rename commands´╝ü

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download

Posted by Tommy at December 16, 2013 - 7:20 PM