Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Get all invalid user objects in user_objects table

SQL> SQL> SELECT    object_type, object_name, status, created, last_ddl_time   2  FROM      user_objects   3  WHERE     object_type IN ('PROCEDURE', 'FUNCTION', 'PACKAGE',   4                            'PACKAGE BODY', 'TRIGGER')   5  AND       status = 'INVALID'   6  and       rownum < 50; OBJECT_TYPE         OBJECT_NAME               STATUS  CREATED ------------------- ------------------------- ------- -------------------- LAST_DDL_ --------- PROCEDURE           DELETE_CUST               INVALID 17-JUL-08 24-JUL-08 PROCEDURE           WAIT                      INVALID 16-JUL-08 24-JUL-08 PACKAGE             WORKPLACE_TYPE_TS         INVALID 16-JUL-08 24-JUL-08 OBJECT_TYPE         OBJECT_NAME               STATUS  CREATED ------------------- ------------------------- ------- -------------------- LAST_DDL_ --------- PACKAGE BODY        WORKPLACE_TYPE_TS         INVALID 16-JUL-08 24-JUL-08 PACKAGE             WORKER_TYPE_TS            INVALID 16-JUL-08 24-JUL-08 PACKAGE             GENDER_TS                 INVALID 16-JUL-08 24-JUL-08 OBJECT_TYPE         OBJECT_NAME               STATUS  CREATED ------------------- ------------------------- ------- -------------------- LAST_DDL_ --------- PACKAGE BODY        GENDER_TS                 INVALID 16-JUL-08 24-JUL-08 PACKAGE             WORKER_TS                 INVALID 16-JUL-08 24-JUL-08 PACKAGE BODY        WORKER_TS                 INVALID 16-JUL-08 24-JUL-08 OBJECT_TYPE         OBJECT_NAME               STATUS  CREATED ------------------- ------------------------- ------- -------------------- LAST_DDL_ --------- PACKAGE BODY        WORKER_TYPE_TS            INVALID 16-JUL-08 24-JUL-08 PROCEDURE           P_RUN_INSERT              INVALID 17-JUL-08 24-JUL-08 PROCEDURE           ROW_AT_A_TIME_TEST        INVALID 17-JUL-08 24-JUL-08 OBJECT_TYPE         OBJECT_NAME               STATUS  CREATED ------------------- ------------------------- ------- -------------------- LAST_DDL_ --------- PROCEDURE           BULK_TEST                 INVALID 17-JUL-08 24-JUL-08 PACKAGE             CLASSPACKAGE              INVALID 28-JUN-08 24-JUL-08 PACKAGE BODY        CLASSPACKAGE              INVALID 28-JUN-08 24-JUL-08 OBJECT_TYPE         OBJECT_NAME               STATUS  CREATED ------------------- ------------------------- ------- -------------------- LAST_DDL_ --------- PROCEDURE           FCREATE                   INVALID 14-JUL-08 24-JUL-08 PROCEDURE           CLOSECUR                  INVALID 14-JUL-08 24-JUL-08 PROCEDURE           SAVESTRINGTOFILE          INVALID 14-JUL-08 24-JUL-08 OBJECT_TYPE         OBJECT_NAME               STATUS  CREATED ------------------- ------------------------- ------- -------------------- LAST_DDL_ --------- PROCEDURE           PUT_BOOLEAN               INVALID 14-JUL-08 24-JUL-08 PROCEDURE           CREINDX                   INVALID 14-JUL-08 24-JUL-08 PROCEDURE           GET_LINE                  INVALID 14-JUL-08 24-JUL-08 OBJECT_TYPE         OBJECT_NAME               STATUS  CREATED ------------------- ------------------------- ------- -------------------- LAST_DDL_ --------- FUNCTION            RECEIVE_MESSAGE           INVALID 14-JUL-08 24-JUL-08 FUNCTION            TRACEIT                   INVALID 14-JUL-08 24-JUL-08 PROCEDURE           SEND_MESSAGE              INVALID 14-JUL-08 24-JUL-08 OBJECT_TYPE         OBJECT_NAME               STATUS  CREATED ------------------- ------------------------- ------- -------------------- LAST_DDL_ --------- PACKAGE             ONECUR                    INVALID 14-JUL-08 24-JUL-08 PROCEDURE           SHOWEMPS                  INVALID 14-JUL-08 24-JUL-08 PROCEDURE           PROCA                     INVALID 14-JUL-08 24-JUL-08 OBJECT_TYPE         OBJECT_NAME               STATUS  CREATED ------------------- ------------------------- ------- -------------------- LAST_DDL_ --------- PROCEDURE           PROCB                     INVALID 14-JUL-08 24-JUL-08 PACKAGE BODY        MYDATE                    INVALID 14-JUL-08 24-JUL-08 PROCEDURE           SHOW_FILE                 INVALID 14-JUL-08 24-JUL-08 OBJECT_TYPE         OBJECT_NAME               STATUS  CREATED ------------------- ------------------------- ------- -------------------- LAST_DDL_ --------- FUNCTION            FOPEN                     INVALID 14-JUL-08 24-JUL-08 FUNCTION            EMP_COUNT                 INVALID 14-JUL-08 24-JUL-08 PROCEDURE           ORG_PROC                  INVALID 15-JUL-08 24-JUL-08 OBJECT_TYPE         OBJECT_NAME               STATUS  CREATED ------------------- ------------------------- ------- -------------------- LAST_DDL_ --------- FUNCTION            F_CURSOR_EXP              INVALID 15-JUL-08 24-JUL-08 PROCEDURE           P_PRINT_REPORT            INVALID 15-JUL-08 24-JUL-08 FUNCTION            F_CURSOR_EXP_COMPLEX      INVALID 15-JUL-08 24-JUL-08 OBJECT_TYPE         OBJECT_NAME               STATUS  CREATED ------------------- ------------------------- ------- -------------------- LAST_DDL_ --------- FUNCTION            GETALLHIERARCHIES         INVALID 15-JUL-08 24-JUL-08 PACKAGE BODY        ORGMASTER                 INVALID 15-JUL-08 24-JUL-08 FUNCTION            F_GET_FORMATTED_ORG_NAME  INVALID 15-JUL-08 24-JUL-08 OBJECT_TYPE         OBJECT_NAME               STATUS  CREATED ------------------- ------------------------- ------- -------------------- LAST_DDL_ --------- PACKAGE BODY        RFPKG                     INVALID 15-JUL-08 24-JUL-08 PACKAGE BODY        RFPKG2                    INVALID 15-JUL-08 24-JUL-08 PACKAGE             NOCOPYPKG                 INVALID 15-JUL-08 24-JUL-08 OBJECT_TYPE         OBJECT_NAME               STATUS  CREATED ------------------- ------------------------- ------- -------------------- LAST_DDL_ --------- PACKAGE BODY        NOCOPYPKG                 INVALID 15-JUL-08 24-JUL-08 PROCEDURE           UPDATE_DYN_GLOBAL_BULK2   INVALID 16-JUL-08 24-JUL-08 PACKAGE BODY        ORGMASTER2                INVALID 15-JUL-08 24-JUL-08 OBJECT_TYPE         OBJECT_NAME               STATUS  CREATED ------------------- ------------------------- ------- -------------------- LAST_DDL_ --------- PROCEDURE           UPDATE_DYN_GLOBAL_BULK    INVALID 16-JUL-08 24-JUL-08 PACKAGE             SRPKG2                    INVALID 15-JUL-08 24-JUL-08 PACKAGE BODY        SRPKG2                    INVALID 15-JUL-08 24-JUL-08 OBJECT_TYPE         OBJECT_NAME               STATUS  CREATED ------------------- ------------------------- ------- -------------------- LAST_DDL_ --------- PROCEDURE           LOG_ERROR                 INVALID 15-JUL-08 25-JUL-08 49 rows selected. SQL>