摘要: SELECT a.object_id, a.session_id, b.object_nameFROM v$locked_object a, dba_objects bWHERE a.object_id = b.object_id 阅读全文
posted @ 2014-05-29 13:58 shisw 阅读(1748) 评论(0) 推荐(0) 编辑
摘要: select t.table_name from user_constraints twhere t.constraint_type='R' and t.r_constraint_namein(select s.constraint_name from user_constraints swhere... 阅读全文
posted @ 2014-05-29 13:57 shisw 阅读(166) 评论(0) 推荐(0) 编辑