Re: Compling objects

Looks like some of the code was cut-off when I cut and pasted. The complete script is below:

spool runobj.sql
SELECT 'alter '||replace(object_type,'BODY')|| ' '||SUBSTR(object_name,1,30)||' compile ' ||decode(object_type,'PACKAGE BODY','body',null)||';'
FROM user_objects
WHERE (object_type IN ('PROCEDURE','TRIGGER','FUNCTION','PACKAGE')

       or object_type like '%PACKAGE%')
  AND status != 'VALID'
order by object_type, object_name
/
spool off
start runobj.sql

John Alexander <jalexander_at_summitsoftwaredesign.com> wrote in message news:wrhi6.109150$Tl3.22135746_at_typhoon.tampabay.rr.com...
> get getobj
> SET PAGESIZE 2000
> spool runobj.sql
> SELECT 'alter '||replace(object_type,'BODY')|| '
> '||SUBSTR(object_name,1,30)||' compile ' ||dec
> FROM user_objects
> WHERE (object_type IN ('PROCEDURE','TRIGGER','FUNCTION','PACKAGE')
> or object_type like '%PACKAGE%')
> AND status != 'VALID'
> order by object_type, object_name
> /
> spool off
> start runobj.sql
>
> John Haran <john_at_haran19.freeserve.co.uk> wrote in message
> news:96c5dc$qd0$1_at_news7.svr.pol.co.uk...
> > Does anyone know a script which will compile all objects (including
> > triggers)
> > within a schema?
> >
> >
> >
>
>
>
Received on Sun Feb 18 2001 - 16:07:25 CET