Re: Export throws ORA-04063 on a brand new DB

Daniel Morgan <damorgan_at_x.washington.edu> wrote:

>
>It would be helpful to know what objects are in an invalid state and who
>owns them.
>
>But off the top of my head I'd start by running catalog, catproc, any
>other relevant scripts, then utlrp again.

Here it goes:

SQL> select object_name,object_type from all_objects where owner='SYS' and status='INVALID';

OBJECT_NAME                    OBJECT_TYPE
------------------------------ ------------------
ALL_WORKSPACES                 VIEW
ALL_XML_SCHEMAS                VIEW
ALL_XML_TABLES                 VIEW
ALL_XML_TAB_COLS               VIEW
ALL_XML_VIEWS                  VIEW
ALL_XML_VIEW_COLS              VIEW
DBA_WORKSPACES                 VIEW
DBA_WORKSPACE_SESSIONS         VIEW
DBA_XML_SCHEMAS                VIEW
DBA_XML_TABLES                 VIEW
DBA_XML_TAB_COLS               VIEW
DBA_XML_VIEWS                  VIEW
DBA_XML_VIEW_COLS              VIEW
KU$_CLUSTER_VIEW               VIEW
KU$_COLUMN_VIEW                VIEW
KU$_FHTABLE_VIEW               VIEW
KU$_IOTABLE_VIEW               VIEW
KU$_M_VIEW_FH_VIEW             VIEW
KU$_M_VIEW_IOT_VIEW            VIEW
KU$_M_VIEW_LOG_FH_VIEW         VIEW
KU$_M_VIEW_LOG_PFH_VIEW        VIEW
KU$_M_VIEW_PFH_VIEW            VIEW
KU$_M_VIEW_PIOT_VIEW           VIEW
KU$_NT_PARENT_VIEW             VIEW
KU$_OPQTYPE_VIEW               VIEW
KU$_PFHTABLE_VIEW              VIEW
KU$_PIOTABLE_VIEW              VIEW
KU$_VIEW_VIEW                  VIEW
KU$_XMLSCHEMA_ELMT_VIEW        VIEW
KU$_XMLSCHEMA_VIEW             VIEW
LOGOFF_PROC                    PROCEDURE
LT                             PACKAGE BODY
LTADM                          PACKAGE
LTADM                          PACKAGE BODY
LTAQ                           PACKAGE BODY
LTDDL                          PACKAGE
LTDDL                          PACKAGE BODY
LTDTRG                         PACKAGE BODY
LTPRIV                         PACKAGE BODY
LTRIC                          PACKAGE
LTRIC                          PACKAGE BODY
LTUTIL                         PACKAGE
LTUTIL                         PACKAGE BODY
LT_CTX_PKG                     PACKAGE BODY
LT_EXPORT_PKG                  PACKAGE BODY
NO_VM_CREATE                   TRIGGER
NO_VM_CREATE_PROC              PROCEDURE
NO_VM_DROP                     TRIGGER
NO_VM_DROP_PROC                PROCEDURE
OWM_DDL_PKG                    PACKAGE
OWM_DDL_PKG                    PACKAGE BODY
OWM_MIG_PKG                    PACKAGE BODY
OWM_REPUTIL                    PACKAGE BODY
SYS_LOGOFF                     TRIGGER
UD_TRIGS                       PACKAGE
UD_TRIGS                       PACKAGE BODY
USER_WORKSPACES                VIEW
USER_XML_SCHEMAS               VIEW
USER_XML_TABLES                VIEW
USER_XML_TAB_COLS              VIEW
USER_XML_VIEWS                 VIEW
USER_XML_VIEW_COLS             VIEW
WM$WORKSPACE_SESSIONS_VIEW     VIEW
WM_DDL_UTIL                    PACKAGE
WM_DDL_UTIL                    PACKAGE BODY
WM_INSTALLATION                VIEW

66 lines Received on Sun Dec 28 2003 - 18:53:36 CST