Path: news.f.de.plusline.net!news-fra1.dfn.de!keepthis.news.telefonica.de!telefonica.de!news.tiscali.de!tiscali!newsfeed1.ip.tiscali.net!proxad.net!cleanfeed2-a.proxad.net!nnrp15-1.free.fr!not-for-mail
From: "Eric" <oups@dba.com>
Newsgroups: comp.databases.oracle.server
References: <45c2604f$0$21113$426a74cc@news.free.fr> <1170402962.860307.309960@v33g2000cwv.googlegroups.com>
Subject: Re: when rebuild IOT ?
Date: Fri, 2 Feb 2007 09:06:38 +0100
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1896
X-Antivirus: avast! (VPS 000709-2, 01/02/2007), Outbound message
X-Antivirus-Status: Clean
Lines: 30
Message-ID: <45c2f075$0$26684$426a74cc@news.free.fr>
Organization: Guest of ProXad - France
NNTP-Posting-Date: 02 Feb 2007 09:04:05 MET
NNTP-Posting-Host: 82.235.189.18
X-Trace: 1170403445 news-2.free.fr 26684 82.235.189.18:1377
X-Complaints-To: abuse@proxad.net
Xref: news.f.de.plusline.net comp.databases.oracle.server:193487


"Gints Plivna" <gints.plivna@gmail.com> a écrit dans le message de
news:1170402962.860307.309960@v33g2000cwv.googlegroups.com...
> Eric wrote:
> > I'm on 9.2.0.5. I have noticed that some IOTs where taking as much 2 to
4
> > times space as they should. Are we supposed to rebuild IOTs, and what
are
> > pros & cons about that ?
> >
> > Thanks,
> >
> > Eric
>
> I assume that rebuilding IOT is quite the same like rebuilding index.
> If you want to know why, when you should rebuild indexes you can read
> this paper http://www.miracleas.dk/images/upload/Docs/Richard
> %20Foote.pdf and search in asktom.oracle.com site for index rebuild
> and you'll get what Tom is thinking about index rebuilds :)
>
> Gints Plivna
> http://www.gplivna.eu

Hi Gints, that's is what I was looking for.

Great thanks,

Eric