编译Oracle所有失效的过程、视图等
摘要:
DECLARE v_oldnum NUMBER (10) := 0; v_newnum NUMBER (10) := 0;BEGIN--自动编译对象 DBMS_OUTPUT.put_line ( '===================================' || CHR (10) || '自动编译对象:' || CHR (10) || '===================================' ); LOOP SELECT COUNT (*) INTO v_newnum FROM dba_objects WHERE status = 'INVALID' AND o 阅读全文
posted @ 2011-01-13 16:28 南工学子 阅读(1036) 评论(0) 推荐(0)
浙公网安备 33010602011771号