Oracle Database query for check invalid object and fix it

** Myself
--Check invalid object
SQL>spool invalid_objects
SQL> select unique object_name, object_type, owner from dba_objects where status = 'INVALID';
--Fix it
SQL>@?/rdbms/admin/utlrp.sql
SQL> select unique object_name, object_type, owner from dba_objects where status = 'INVALID';
SQL>spool off

0 comments:

Loading