RE: VERY URGENT -- Catrep.sql

From: Adams, Matthew (GEA, 088130) <MATT.ADAMS_at_APPL.GE.COM>
Date: Thu, 9 Nov 2000 10:49:24 -0500
Message-Id: <10675.121590@fatcity.com>

Ruth,

Why run catexp at all? In all versions I checked, catexp.sql is run from catalog.sql.

---

R. Matt Adams - GE Appliances - matt.adams_at_appl.ge.com

     Building a new system can be accomplished in three modes
     Good, Fast, Cheap   
     Pick your favorite two.

> Try :
> execute dbms_utility.compile.schema ('SCHEMA_NAME')
>
> This will compile all objects in the schema which has the
> invalid objects.
> You can find out which objects are invalid and the schema_name by :
> select object_type, object_name, owner from dba_objects where
> status='INVALID';
>
> However, one other thought, did you run catalog.sql before you ran
> catproc.sql? The proper order is catalog, catproc, catexp.
Received on Thu Nov 09 2000 - 09:49:24 CST