Select number of Invalids
select * from dba_objects where status='INVALID' and owner='APPS'
From sqlplus as apps/apps user
------------
SQL> execute sys.utl_recomp.recomp_serial('APPS');
PL/SQL procedure successfully completed.
------------
From Toad
----------
begin
sys.utl_recomp.recomp_serial('APPS');
end;
----------
Verify Invalids after compilation.
select * from dba_objects where status='INVALID' and owner='APPS'
Thats It..........
select * from dba_objects where status='INVALID' and owner='APPS'
From sqlplus as apps/apps user
------------
SQL> execute sys.utl_recomp.recomp_serial('APPS');
PL/SQL procedure successfully completed.
------------
From Toad
----------
begin
sys.utl_recomp.recomp_serial('APPS');
end;
----------
Verify Invalids after compilation.
select * from dba_objects where status='INVALID' and owner='APPS'
Thats It..........
No comments:
Post a Comment