--表备份
create table xxx_bak as select * from xxx;
--表数据清除
truncate table xxx
--锁表问题处理sql开始
select session_id from v$locked_object,user_objects where v$locked_object.object_id = user_objects.object_id;--查询session_id
select serial# from v$session where sid = ‘1181‘;--查询serial
alter system kill session ‘1181,11454‘;--根据查到的session_id和serial执行
--锁表问题处理sql结束