My warning on space depends on how the indexes are distributed across
tablespaces. If they were all in one tablespace and enough space
existed to rebuild the largest then, no problem. If all three indexes
where in different tablespaces then obviously you would need to check
the availability of free space in each tablespace. This warning was
really intended for anyone fairly new who has to work on a database he
or she is unfamiliar with. Just assuming that enough temp exists to
rebuild an index is pretty common but if the database was laid down
three years ago an index may have grown enough to exceed the available
resources.
HTH -- Mark D Powell --
Received on Wed Jan 04 2006 - 09:32:49 CST
