如何檢測oracle里面的索引和存儲過程是否失效？
SELECT * FROM dba_objects t where t.OBJECT_TYPE='PROCEDURE';
SELECT * FROM dba_objects t where t.OBJECT_TYPE='INDEX';
dba_objecst里面有個status字段,valid為有效，invalid即為失效
網站導航
- zblogPHP模板zbpkf
- zblog免費模板zblogfree
- zblog模板學習zblogxuexi
- zblogPHP仿站zbpfang