Friday, December 10, 2010

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('', FAlSE);

Ex;

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

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

No comments: