Database Administration (MOSC)

MOSC Banner

UTL_RECOMP not working

edited Jun 3, 2009 7:23AM in Database Administration (MOSC) 7 commentsAnswered
Hello,

I want to recompile the invalid objects in a schema using
sql>utl_recomp.recomp_parallel('my_schema');

The command works fine but all the objects still remain invalid. Nothing changes. I run the command as sys user. There is no error in object's script because I can compile them using TOAD GUI. But I don't want to be TOAD dependent. I want to be able to compile invalid objects using utl_recomp utility. Any ideas about what might be going wrong?

Emrah

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center