| |
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.
|
| March 03, 2006 21:01:10 |
#1 |
| Parveeb Ahuja |
Member Since: Visitor Total Comments: N/A |
RE: Very next day on the prodction box It looks some p...
|
| Use dbms_utility.compile_schema procedure to compile all the functions,procedure and packages for a schema.exec dbms_utility.compile_schema('schema_name'); |
| |
Back To Question | |
