Re: Indexes of Table 'INVALID' after 'alter Table add <Column>'

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 29 Nov 1999 09:29:46 -0000
Message-ID: <943868827.25118.0.nnrp-13.9e984b29@news.demon.co.uk>

There used to be a bug with bitmap indices going invalid in these circumstances; I thought it had been fixed by 8.0.5 -

Your theory is correct, adding a column should NOT invalidate an index.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Karl R. wrote in message <000b8d9b.27266bfb_at_usw-ex0102-009.remarq.com>...
>Hello!
>
>ORACLE: 8.0.5.2.0: OS: NT 4.0 SP3
>
>I added some new columns to the table. After that i detetcted that
>almost all indexes changed there status to 'invalid'.
>Why?.
>I think adding new columns to the table never changes the rowid of the
>table-row and so all old indexes should not become 'invalid' ?
>
>Do you have an idea??
>
>
>
>* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
>The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Mon Nov 29 1999 - 03:29:46 CST