Re: Invalid objects

Pinchas:

Try running catproc.sql. It is located in /ORACLE_HOME/rdbms/admin directory. But before running this script, make sure that STANDARD.sql and DBMSSTDX.sql first to avoid errrors.

Noly

Pinchas Nisenson <nisenson_at_acs.ucalgary.ca> wrote in article <61bo72$n3q_at_ds2.acs.ucalgary.ca>...
> I just finished building a database. After checking for invalid
> objects I found dbms that DBMS_SNAPSHOT is invalid.
> Looked it up it said that dbmssnap.sql and prvtsnap.plb have to
> be run.
> I did so and got more errors. That I decided to rerun catalog.sql
> + catdbsyn.sql
> hoping to get rid of errors alas I got even more invalid objects.
>
> Any suggestion to how to get rid of the invalid objects.
> =======================================
> SQLWKS> select owner,object_name,object_type from dba_objects
> 2> where status = 'INVALID';
> OWNER OBJECT_NAME
> OBJECT_TYPE
> ------------------------------ ------------------------------
> -------------
> SYS ALL_ADMINCATLOG
> VIEW
> SYS ALL_ADMINOBJECTS
> VIEW
> SYS ALL_ADMINREGSNAPS
> VIEW
> SYS ALL_ADMINRESOLUTION
> VIEW
> SYS ALL_REPCATLOG
> VIEW
> SYS ALL_REPDDL
> VIEW
> SYS ALL_REPGENERATED
> VIEW
> SYS ALL_REPKEY_COLUMNS
> VIEW
> SYS ALL_REPOBJECT
> VIEW
> SYS ALL_REPPROP
> VIEW
> SYS DBMSOBJG
> PACKAGE BODY
> SYS DBMSOBJGWRAPPER
> PACKAGE BODY
> SYS DBMS_DEFERGEN_UTIL
> PACKAGE BODY
> SYS DBMS_OFFLINE_OG
> PACKAGE BODY
> SYS DBMS_OFFLINE_SNAPSHOT
> PACKAGE BODY
> SYS DBMS_RECTIFIER_DIFF
> PACKAGE BODY
> SYS DBMS_RECTIFIER_FRIENDS
> PACKAGE BODY
> SYS DBMS_REPCAT
> PACKAGE BODY
> SYS DBMS_REPCAT_AUTH
> PACKAGE BODY
> SYS DBMS_REPCAT_CONF
> PACKAGE
> SYS DBMS_REPCAT_CONF
> PACKAGE BODY
> SYS DBMS_REPCAT_MAS
> PACKAGE BODY
> SYS DBMS_REPCAT_SNA
> PACKAGE BODY
> SYS DBMS_REPCAT_SNA_UTL
> PACKAGE BODY
> SYS DBMS_REPCAT_UTL
> PACKAGE BODY
> SYS DBMS_REPCAT_UTL2
> PACKAGE BODY
> SYS DBMS_REPCAT_UTL3
> PACKAGE BODY
> SYS DBMS_UTILITY
> PACKAGE BODY
> SYSTEM ROSATTRIBS VIEW
> SYSTEM ROSSTRUCTS VIEW
> ==========================================
> Please reply directly to my e-mail .
>
>
> Thanks ..
> =========================
> Pinchas Nisenson
> Data Base Manager
> University (of Calgary) Computing Services
> E-mail: nisenson_at_acs.ucalgary.ca
> Phone: (403) 220-4447
> Fax: (403) 282-9361
>
>
>
Received on Tue Oct 07 1997 - 00:00:00 CDT