Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Why This Objects Are Invalid?
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
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
![]() |
![]() |