Re: Compling objects
From: John Alexander <jalexander_at_summitsoftwaredesign.com>
Date: Tue, 13 Feb 2001 21:13:00 GMT
Message-ID: <wrhi6.109150$Tl3.22135746_at_typhoon.tampabay.rr.com>
Date: Tue, 13 Feb 2001 21:13:00 GMT
Message-ID: <wrhi6.109150$Tl3.22135746_at_typhoon.tampabay.rr.com>
get getobj
SET PAGESIZE 2000
spool runobj.sql
[Quoted] 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 Tue Feb 13 2001 - 22:13:00 CET