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 -----
From: lerobe - Lee Robertson <LEROBE_at_acxiom.co.uk>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Tuesday, October 24, 2000 9:25 AM
Subject: RE: Partition rebuilds
> 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
>
>
>
> -----Original Message-----
> Sent: 24 October 2000 14:09
> To: lerobe - Lee Robertson
>
>
> Lee,
>
> I seem to remember that I did rebuild an partition index on its own, is uses
> the information in the current global index for that table. So if you just
> want to rebuild the index to change storage parameters or something like
> that - you can.
>
> But I think if you add data - you may have to rebuild the whole lot - but
> you can in parallel.
>
> -----Original Message-----
> Sent: 24 October 2000 11:31
> To: akhiro - Asit Khiroya
> Cc: gnewso - Gary Newsome
>
>
> Asit,
>
> As part of my planned maintenance for ADW, Gary N. and I had come up with a
> few ideas. One of which was to rebuild the PG_UK_CUSTOMER_BRAND13 partition.
> This would free up approx. 2.5Gb (one of the least important ones we
> discovered).
>
> Do you know of any problems or gotchas with rebuilding partitions.
>
> As I can see it, if you rebuild the partition, the entire corresponding
> index (not just the relevant partition) needs to be rebuilt afterwards. Is
> this true ?? If it is then it isnt worth the partition rebuild.
>
> Regards
>
>
>
>
> Lee Robertson
> Acxiom
> Tel: 0191 525 7344
> Fax: 0191 525 7007
> Email: lerobe_at_acxiom.co.uk
>
>
>
>
>
> The information contained in this communication is
> confidential, is intended only for the use of the recipient
> named above, and may be legally privileged. If the reader
> of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or
> copying of this communication is strictly prohibited.
> If you have received this communication in error, please
> re-send this communication to the sender and delete the
> original message or any copy of it from your computer
> system.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: lerobe - Lee Robertson
> INET: LEROBE_at_acxiom.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Tue Oct 24 2000 - 12:20:52 CDT
