Compile INVALIDS of any SCHEMA

Earlier to this, I used the following commands to compile INVALID objects of any database

1. @?/rdbms/admin/utlrp
2. exec utl_recomp.recomp_parallel(threads=>5)
3. alter package/ procedure compile ... comand

I found one more utility that will help us to compile the invalids of any particular schema

exec dbms_utility.compile_schema('<schema_name>', FAlSE);


exec dbms_utility.compile_schema('SCOTT', FAlSE);

We used “FALSE” as we have to compile invalids only not the whole schema.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: