Compiling Invalid Objects Scripts

[admin]

1)

BEGIN
DBMS_UTILITY.compile_schema
(
schema => 'your schema nme', compile_all => FALSE
);
END;
/

2)

SELECT 'ALTER ' || OBJECT_TYPE || ' ' || OWNER || '.' || OBJECT_NAME || ' COMPILE;'
FROM DBA_OBJECTS
WHERE STATUS = 'INVALID';

3)

SET SERVEROUTPUT ON
DECLARE
v_sql VARCHAR2(200);
BEGIN
FOR cur_rec IN (SELECT OWNER, OBJECT_TYPE, OBJECT_NAME
FROM DBA_OBJECTS
WHERE STATUS = 'INVALID')
LOOP
v_sql := 'ALTER ' || cur_rec.OBJECT_TYPE || ' ' || cur_rec.OWNER || '.' || cur_rec.OBJECT_NAME || ' COMPILE';
BEGIN
EXECUTE IMMEDIATE v_sql;
DBMS_OUTPUT.PUT_LINE('Compiled ' || cur_rec.OBJECT_TYPE || ' ' || cur_rec.OWNER || '.' || cur_rec.OBJECT_NAME);
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('Error compiling ' || cur_rec.OBJECT_TYPE || ' ' || cur_rec.OWNER || '.' || cur_rec.OBJECT_NAME || ': ' || SQLERRM);
END;
END LOOP;
END;
/