|
-
You can compile all objects that are invalid with this script:
set heading off;
set feedback on;
set pages 10000;
spool &&spoolfile
select 'alter '||object_type, object_name
||' compile;'
from user_objects
where status = 'INVALID'
and object_type != 'PACKAGE BODY'
union
select 'alter package '||NULL, object_name
||' compile body;'
from user_objects
where status = 'INVALID'
and object_type = 'PACKAGE BODY';
spool off
@&&spoolfile;
host del &&spoolfile;
undefine spoolfile;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|