爬爬代码工博客

--*oracle中查看表是否被锁 *SELECT /*+ rule*/ a.sid, b.owner, object_name, b.object_type FROM v$lock a, all_objects b WHERE a.TYPE = 'TM' and a.id1 = b.object_id; --查到的都是被锁的表 ，这样可以把它杀掉 替换&sid参数SELECT sid,seri

一.恢复被覆盖（删除）的视图: 1. 授权:使用sys用户登陆,执行命令 grant flashback on sys.dba_views to cmms3; 2. 执行以下语句查询某个时间点的视图 select * from SYS.DBA_viewsas of timestamp to_date('20170306105700','yyyymmddhh24miss')where