Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Why This Objects Are Invalid?

Why This Objects Are Invalid?

From: Kekko <dini.f_at_adr.it>
Date: Mon, 12 Jul 1999 10:18:40 +0200
Message-ID: <3789A4E0.477B38A2@adr.it>


SQLWKS> select owner,object_name,object_type,status from dba_objects where status = 'INVALID';

OWNER                          OBJECT_NAME
OBJECT_TYPE     STATUS
------------------------------ ------------------------------
--------------- -------
SYS                            AQ$_DUMMY_T
TYPE            INVALID
SYS                            DBMS_AQADM                     PACKAGE
BODY    INVALID
SYS                            DBMS_DEFER                     PACKAGE
BODY    INVALID
SYS                            DBMS_DEFERGEN                  PACKAGE
BODY    INVALID
SYS                            DBMS_DEFERGEN_AUDIT            PACKAGE
BODY    INVALID
SYS                            DBMS_DEFERGEN_INTERNAL         PACKAGE
BODY    INVALID
SYS                            DBMS_DEFERGEN_PRIORITY         PACKAGE
BODY    INVALID
SYS                            DBMS_DEFERGEN_RESOLUTION       PACKAGE
BODY    INVALID
SYS                            DBMS_DEFER_QUERY               PACKAGE
BODY    INVALID
SYS                            DBMS_DEFER_QUERY_UTL           PACKAGE
BODY    INVALID
SYS                            DBMS_DEFER_REPCAT              PACKAGE
BODY    INVALID
SYS                            DBMS_DEFER_SYS                 PACKAGE
BODY    INVALID
SYS                            DBMS_DEFER_SYS_PART1           PACKAGE
BODY    INVALID
SYS                            DBMS_MAINT_GEN                 PACKAGE
BODY    INVALID
SYS                            DBMS_OFFLINE_SNAPSHOT          PACKAGE
BODY    INVALID
SYS                            DBMS_REPCAT_SNA                PACKAGE
BODY    INVALID
SYS                            DBMS_REPCAT_SNA_UTL            PACKAGE
BODY    INVALID
SYS                            DBMS_REPCAT_UTL                PACKAGE
BODY    INVALID
SYS                            DBMS_REPUTIL                   PACKAGE
BODY    INVALID
SYS                            DBMS_REPUTIL2                  PACKAGE
BODY    INVALID
SYS                            DBMS_SNAPSHOT                  PACKAGE
BODY    INVALID
SYS                            DSC_DBA1
PACKAGE         INVALID
SYS                            EXCEPTION_VIEW
VIEW            INVALID
SYS                            PROC_DELETE_INVOICE
PROCEDURE       INVALID

24 rows selected.

Why?

I re-executed catalog.sql and catproc.sql and the situation isn't changed.

Oracle 8.0.5
Digital UNIX 4,0d Received on Mon Jul 12 1999 - 03:18:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US