A record of a table in the marshal database is locked and cannot be modified or deleted (only the hourglass is displayed. This is the case for an hour). The table object cannot be deleted. The error "ORA_00054:" is returned: when resources are busy, you must specify NOWAIT solution: 1. In the current session, both commit and rollback can be unlocked. 2. When other sessions (DBAs) Pass
A record of a table in the marshal database is locked and cannot be modified or deleted (only the hourglass is displayed. This is the case for an hour). The table object cannot be deleted. The error "ORA_00054:" is returned: when resources are busy, you must specify NOWAIT solution: 1. In the current session, both commit and rollback can be unlocked. 2. When other sessions (DBAs) Pass
A record of a table in the marshal database is locked and cannot be modified or deleted (only the hourglass is displayed. This is the case for an hour). You cannot delete the table object, and an error is returned:
ORA_00054: the resource is busy. You must specify NOWAIT.
Solution:
1. Both commit and rollback can be unlocked in the current session.
2. Pass
Search for user locks
Select s. username,
Decode (l. type, 'TT', 'table lock ',
'Tx ', 'row lock ',
NULL) LOCK_LEVEL,
O. owner, o. object_name, o. object_type,
S. sid, s. serial #, s. terminal, s. machine, s. program, s. osuser
From v $ session s, v $ lock l, dba_objects o
Where s. sid = l. sid
And o. object_id = l. id1
And s. username is not null
Check who has locked the table.
In the result, object_name = 'your table name'
Then get sid, serial #
Alter system kill session 'sid, serial #'
Or
Alter system disconnect session 'sid, serial # 'immediate;
3. select * from table for update nowait can specify nowait