SQL> create index abc on xys (object_id) tablespace mytbs;
create index abc on xys (object_id) tablespace mytbs
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified
SELECT a.SID, a.serial#
2 FROM v$session a, v$locked_object b, DBA_OBJECTS c
3 WHERE b.object_id = c.object_id
4 AND a.SID = b.session_id AND OBJECT_NAME='XYS';
SID SERIAL#
---------- ----------
158 25604
- Commit or rollback the statement causing issue
- Wait till release resources
- Kill that session using
alter system kill session 'sid,serial#'
No comments:
Post a Comment