** 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:
Post a Comment