ORA-00054

时间:2023-03-08 22:34:46
ORA-00054

系统版本:

[root@yoon ~]# more /etc/oracle-release
Oracle Linux Server release 5.7

数据库版本:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

ORA-00054 (无法truncate、drop table)

解决办法:

SQL>select session_id from v$locked_object;

----SESSION_ID
117

SQL>select sid,serial#,username,osuser from v$session where sid=117;
------SID SERIAL# USERNAME OSUSER 
117 120 EMP LILWEN

SQL>alter system kill session '117,120';

SQL>truncate table emp; --OK

SQL>drop table emp; --OK