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('
Ex;
exec dbms_utility.compile_schema('SCOTT', FAlSE);
We used “FALSE” as we have to compile invalids only not the whole schema.
No comments:
Post a Comment