| |
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.
|
| April 04, 2009 08:21:05 |
#6 |
| samareshp |
Member Since: April 2009 Total Comments: 23 |
RE: 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 va
|
| select * from all_objects where object_type='PACKAGE' and status= 'INVALID' ; |
| |
Back To Question | |
