Re: catrep.sql

From: <denny_vk_at_my-dejanews.com>
Date: Fri, 28 Aug 1998 02:26:45 GMT
Message-ID: <6s54h4$vlb$1@nnrp1.dejanews.com>

Shaul,

How did you try to compile the invalid package ? Did you specify compile body ? If you compile the specification, other objects depending on the compiled package will be invalidated.

Denny

In article <35E2C63B.E176C655_at_ibm.net>, sbenyo_at_ibm.net wrote:
> Hi,
>
> I ran the distributed / replication option script CATREP.SQL on my
> oracle 7.3.3 (NT)
> Everything seems to be right except that the package dbms_snapshot is
> invalid.
> When I tried to compile this package again 3 other packages got invalid
> as well.
> Trying to guess and compile the other invalid packages just got me into
> deeper trouble.
>
> a) Is there anything I should do before I run CATREP ? (tablespaces,
> initial parameters?)
> b) Is there a simple way to get rid of all the objects CATREP created?
> c) Is there a way to get all the dependencies & recompile the packages
> in the right order ?
>
> 10X
> Shaul
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 27 1998 - 21:26:45 CDT