How to Compile a Schema in oracle

Use the supplied package procedure DBMS_UTILITY.COMPILE_SCHEMA. It Compiles all PLSQL objects in a schema.

EXECUTE DBMS_UTILITY.COMPILE_SCHEMA('SCHEMA_NAME');

ex:- EXECUTE DBMS_UTILITY.COMPILE_SCHEMA('SCOTT'); 

NOTE: Recompiles all stored packages, procedures and functions in the specified schema in dependency order.

NOTE:- It applies to 9.2.0.8 and later.