| |
GeekInterview.com > Interview Questions > Oracle > Scenarios
| Print | |
Question: Very next day on the prodction box It looks some procedres/packages got invlidated. What command I should give to know how many packges are invalidated. If suppose thousands are the packages invalidated then what command I should Issut to get then validated.
|
| October 10, 2006 04:18:44 |
#4 |
| GIGI GEORGE |
Member Since: Visitor Total Comments: N/A |
RE: Very next day on the prodction box It looks some p...
|
| select 'alter '|| DECODE(object_type, 'PACKAGE BODY', 'PACKAGE', object_type)||' '||object_name||' compile;' from user_objects where status<>'VALID' order by object_type try ot this... then copy and paste on sql prompt..cheersbye |
| |
Back To Question | |
