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.
Use dbms_utility.compile_schema procedure to compile all the functions,procedure and packages for a schema.exec dbms_utility.compile_schema('schema_name');
Above answer was rated as good by the following members: aravindhreturns
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');
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
RE: Very next day on the prodction box It looks some p...
The best way to check for the number of invalid objects is using the "UTLRP.SQL" which compiles all the objects source code and lists the number of invalid objects. One after getting the number of invalid objects query v$BH table to get the name of all the invalid objects
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' ;
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
we can use the @?/rdbms/admin/utlrp.sql
The below listed are the scripts that were executed to valid the DBMS_STAT on particular databses.
1 
0