DBA管理脚本大全(七)
UR_OBJECTS;
LOOP
FETCH CUR_OBJECTS INTO OBJ_LIST;
EXIT WHEN CUR_OBJECTS%NOTFOUND;
SQLTEXT:='ALTER '||OBJ_LIST.OBJECT_TYPE||' "'||OBJ_LIST.OBJECT_NAME||'" COMPILE';
EXECUTE IMMEDIATE SQLTEXT;
END LOOP;
CLOSE CUR_OBJECTS;
END RECOMPILE_ALL_PROJECTS;
/