Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to restrict connections but allow export
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:50:39 CST