Skip to Content
0
Former Member
Jan 22, 2014 at 10:11 AM

Only Tables (no secondary indexes) Online Reorg with BrSpace

120 Views

Hi all,

We are struggling with a huge table reorg (more than 1.5 TB). We manage to reorg the table after several hours but the reorg failed when Brspace tried to rebuild one of the secondary index. Due to this, all the reorg was rolled back and we lost our maintentance window.

My question is if would be possible to run an online reorg for just the table and the primary index. After that we can rebuild the secondary indexes and just rerun the rebuild again in case of failure.

One option is to drop the indexes before and recreate after the reorg, but I'm looking for a more elegant solution.

Many thanks in advanced,