-- from DBA account
 SELECT 
 'alter '||decode(object_type,'PACKAGE BODY','PACKAGE',object_type) ||' '||owner||
  '."'||object_name||'" '||decode(object_type,'PACKAGE BODY','COMPILE BODY','COMPILE')||';' 
 FROM all_objects 
 WHERE owner like '%'
 AND owner not in ('SYS', 'SYSTEM')
 AND object_type IN 
 ('PACKAGE','PACKAGE BODY','VIEW','PROCEDURE','TRIGGER','FUNCTION') 
 AND status='INVALID';

SQL> create table t (col1 number);
Table created.

SQL> create index t_ix1 on t(col1);
Index created.

SQL> CREATE OR REPLACE PROCEDURE t_proc
  2  AS
  3     v1   t.col1%TYPE;
  4  BEGIN
  5     NULL;
  6  END;
  7  /
Procedure created.

SQL> select status from user_objects where object_name = 'T_PROC';

STATUS
-------
VALID

SQL> alter table t move tablespace users;
Table altered.

SQL> alter index t_ix1 rebuild tablespace users;
Index altered.

SQL> select status from user_objects where object_name = 'T_PROC';
STATUS
-------
VALID