oracle 删除临时表

1.查询出那些session正在锁住临时表

select sid,serial# 
from v$session 
where sid in (select sid 
              from v$lock   
             where id1= (select object_id 
                           from user_objects   
                          where object_name=upper('enterprise_report_tmp')));

2.删除session

alter system kill session 'sid,serial#';
commit;

3.删除临时表

truncate table tablename;
drop table tablename;