先扫描是否有INVALID的对象。
SQL> select owner, object_name, object_type, status from dba_objects where status = 'INVALID';
SQL> select count(*) from dba_objects where status = 'INVALID';
SQL> select count(*) from dba_objects where status = 'INVALID';