Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Indexes of Table 'INVALID' after 'alter Table add <Column>'
Thank you for your hint!
/Karl Reitschuster
In article <943868827.25118.0.nnrp-13.9e984b29_at_news.demon.co.uk>,
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
> 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!
> >