Views and triggers invalidated after creating and/or dropping ind

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Fri, 17 Nov 2000 12:47:27 -0500
Message-Id: <10683.122392@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C050BE.785DA470
Content-Type: text/plain;

charset="iso-8859-1"

Oracle 8.1.6.2, Sun Solaris 7.

Anybody have any idea why dropping indexes can cause invalidation of views?

Alex Hillman

------_=_NextPart_001_01C050BE.785DA470
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2448.0">
<TITLE>Views and triggers invalidated after creating and/or dropping indexes</TITLE>
</HEAD>
<BODY>

Oracle 8.1.6.2, Sun Solaris 7.


Anybody have any idea why dropping indexes can cause invalidation of views?


Alex Hillman


</BODY>
</HTML>

------_=_NextPart_001_01C050BE.785DA470-- Received on Fri Nov 17 2000 - 11:47:27 CST