- 博客(2)
- 收藏
- 关注
RSS订阅转载 oracle恢复被删表数据
查询数据库对象（表，存储过程等）什么时候被修改过-- 查询最后修改的对象SELECT object_name,CREATED,LAST_DDL_TIME from user_objects order by last_ddl_time desc;SELECT object_name,CREATED,LAST_DDL_TIME from user_objects order by created desc;数据库数据被删掉，恢复删掉的数据--数据库恢复insert into sys_user
2021-03-02 12:00:52
181
转载 oracle锁表、锁存储过程
锁表--查询被锁的表select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.object_id;--查看是哪个session引起的select b.username,b.sid,b.serial#,logon_time from v$locked_object a,v$session b where a.session_id
2021-03-02 11:54:19
715
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人