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-----

From: akhiro - Asit Khiroya
Sent: 24 October 2000 14:09
To: lerobe - Lee Robertson
Subject: RE: Partition rebuilds

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-----

From: lerobe - Lee Robertson
Sent: 24 October 2000 11:31
To: akhiro - Asit Khiroya
Cc: gnewso - Gary Newsome
Subject: Partiton rebuilds

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 Received on Tue Oct 24 2000 - 08:24:19 CDT