| select |
OWNER,
OBJECT_TYPE,
OBJECT_NAME,
STATUS |
| from |
dba_objects |
| where |
STATUS = 'INVALID' |
|
|
| order by |
OWNER, OBJECT_TYPE, OBJECT_NAME; |
|
|
| select |
'alter '||object_type||' '||owner||'.'||object_name||'
compile;' |
|
|
| from |
dba_objects |
|
|
| where |
status = 'INVALID' |
| and |
object_type != 'PACKAGE BODY' |
| UNION |
|
| select |
'alter package '||owner||'.'||object_name||'
compile body;' |
| from |
dba_objects |
| where |
status = 'INVALID' |
| and |
object_type = 'PACKAGE BODY'; |
