Re: Cannot compile some views...

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 02 Jun 2007 08:44:38 -0700
Message-ID: <1180799076.748090@bubbleator.drizzle.com>

astalavista wrote:
> Hi,
>
> I have some views in a schema which I can't compile from user system
> these views have select ... from select ...
> but I can compile from the owner.

No DDL, no error message, no help.

> So these views are not automatically compiled when used.
> For others views I can compile from system.

You could get a supported version of the product.

> is it a bug or a feature ?
> Oracle 8.1.7.0

Neither. If you are going to use a paleolithic version of the product at least apply the released patches. And as indicated above ... if you want help ... you need to provide sufficient information for someone to help you.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Sat Jun 02 2007 - 10:44:38 CDT