It's not just the 8.0.5 and partitioning, whenever the rowid in table
changes (during defragmentation tasks, for example), all the indexes
containing that rowid become useless. That's why they need to be rebuilt to
get the new rowids.
This was one of the reasons we chose to stay with just local indexes for our
partitioned tables (and the Appl did not have a need for any global or
non-partitioned indexes). So only one partition is affected and not
available during defragmentation efforts....
- Kirti
> -----Original Message-----
> From: Tom Pall [SMTP:tom_at_cdproc.com]
> Sent: Tuesday, October 24, 2000 1:22 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Partition rebuilds
>
> It is sad but true. Even sader is that you are running Oracle 8.0, which
> places
> a share lock on the table during index rebuilds.
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, October 24, 2000 9:25 AM
>
>
> > All,
> >
> > Oracle 8.0.5
> >
> > I want to defragment a partition for space reasons but I am sure I read
> > somewhere (SQL Reference) that if you do that then you need to rebuild
> the
> > whole index, as it marks all local index partitions, non-partitioned
> global
> > indexes and partitioned global indexes as unuseable and therefore
> needing to
> > be rebuilt.
> >
> > Is this true or have I got a hold of the wrong end of the stick ? If it
> is
> > then there is no point in doing this as it would take too much time.
> >
> > TIA
> >
> > Lee Robertson
> > Acxiom
> > Tel: 0191 525 7344
> > Fax: 0191 525 7007
> > Email: lerobe_at_acxiom.co.uk
Received on Tue Oct 24 2000 - 21:37:23 CDT
