Is there any wrong with dbms_utility.compile_schema procedure. Whenever i try to recompile objects in a schema using
exec dbms_utility.compile_schema(USER);
the session hangs (and after 3 or 4 hours i terminate the execution). I always have to manually recompile objects using PL/SQL developer. Is there an alternative to dbms_utility.compile_schema procedure?