Day: September 2, 2024

ORA-14473: Mapping table cannot be dropped while there are failed online partition maintenance

Potential Reason: Rollback is still undergoing for a failed table rebuilding or table removing to new tablespace, etc.

ORA-00054: resource busy and acquire with NOWAIT

To check which session is holding the object:

select a.inst_id, sid, serial#, username, machine  
from gv$session a, gv$locked_object b, dba_objects c
where b.object_id = c.object_id
and a.sid = b.session_id
and a.inst_id=b.inst_id
and OBJECT_NAME='TABLENAME';


INST_ID SID   SERIAL#  USERNAME    MACHINE    OWNER      OBJECT_NAME          
------- ----- ------- ---------- -----------  ---------- ------------- 
2       3365  42069      SYS      TESTSERVER  TESTUSER   TABLENAME

Kill the session, then the error should disappear.