查看数据库中无效的对象

Set line 132

Set wrap off

Set pagesize 49999

col OWNER  for a10

Col  OBJECT_NAME for  a30

Col  OBJECT_TYPE for a11

SELECT OWNER, OBJECT_NAME, OBJECT_TYPE, STATUS FROM DBA_OBJECTS WHERE STATUS = 'INVALID' ORDER BY OWNER, OBJECT_TYPE, OBJECT_NAME ;

 

OWNER        OBJECT_NAME     OBJECT_TYPE        STATUS

------------ --------------- ------------------ -------

CWJKPRC      RF_DEVICECHANGE PROCEDURE          INVALID

CWJKPRC      RF_DEVICENEW    PROCEDURE          INVALID

CWJKPRC      RF_SUBRACKCHANG PROCEDURE          INVALID

WGJKPRC      F_STR           FUNCTION           INVALID

WGJKPRC      RENEW_WHOLE     PACKAGE BODY       INVALID

WGJKPRC      INCR_WHOLE_ROUT PROCEDURE          INVALID

WGJKPRC      UPDATE_MN_CIRCU PROCEDURE          INVALID

WGJKPRC      UPDATE_MN_CIRCU PROCEDURE          INVALID

WGJKPRC      UPDATE_MN_CIRCU PROCEDURE          INVALID

WGJKPRC      UPDATE_ORDER_NU PROCEDURE          INVALID

 

SQL> select count(*) from dba_objects where status ='INVALID';

 

  COUNT(*)

----------

       406

 

 

编译无效对象脚本：

@$ORACLE_HOME/rdbms/admin/utlrp.sql

 

 

 

SQL> select count(*) from dba_objects where status ='INVALID';