Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Auditing when a view goes invalid?

Re: Auditing when a view goes invalid?

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Thu, 03 Feb 2005 15:26:55 +0100
Message-ID: <cttc8e$rb3$4@news3.zwoll1.ov.home.nl>


Moritz Klein wrote:
> Hello NG,
> first of all the system informations:
>
> OS: Windows 2003 Server
> DBMS: Oracle Enterprise Server 10.1.0.3
>
> Is it possible to audit when a view goes invalid and log information of the
> actual sessions and maybe reason of this event?
>
> I'm asking this because some views in the sys-schema became invalid multiple
> times. Recompiling just work without changes to the views, but that does not
> solve the problem.
>
> Any hints are welcome.
>
> Thanks in advance
> Moritz

Audit DDL, probably - views do not get invalid for a reason, so I suspect you are changing layout of tables, which is a bad idea.

-- 
Regards,
Frank van Bortel
Received on Thu Feb 03 2005 - 08:26:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US