Monday, 8 February 2016

Compiling apps invalids from sql prompt or Toad

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..........

No comments:

Post a Comment

SQL Shared Area - BIND MISMATCH