| |
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, 2006 12:07:09 |
#2 |
| pandish |
Member Since: April 2006 Total Comments: 6 |
RE: Very next day on the prodction box It looks some p...
|
| and use following sql to find the invalid objects.select * from all_objects or dba_objects where status = 'INVALID' ; |
| |
Back To Question | |
