Rick Denoire wrote:
> 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
These objects are owned by different schemas. Have you reviewed the
upgrade logs to see what went wrong? Because something obviously did.
Personally ... I'd review the log and then repeat the upgrade.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Mon Dec 29 2003 - 10:51:31 CST
