Invalid objects

From: Pinchas Nisenson <nisenson_at_acs.ucalgary.ca>
Date: 1997/10/06
Message-ID: <61bo72$n3q@ds2.acs.ucalgary.ca>#1/1

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 Mon Oct 06 1997 - 00:00:00 CDT