Determining space requirements for rebuilding the indexes

Before running index_rebuild, determine that the index and TEMP tablespaces have enough space. Use the check_rebuild_space utility, which reports the additional amount of space that is needed for the index or TEMP tablespace.

To determine space requirements for rebuilding the indexes

Log into the Oracle Server as the oracle (Solaris) or AgfaService (Windows) user.
If running on Windows 64-bit, to set the ORACLE_HOME environment variable, type
set ORACLE_HOME=C:\oracle\product\10.2.0\db_1

This step is not required on Solaris nor on Windows 32-bit.
On Solaris, type the following command:
check_rebuild_space
On Windows, type the following command:
bash check_rebuild_space

The check_rebuild_space utility requires that the size of TEMP be twice the size of the largest index being rebuilt. This ensures that enough TEMP tablespace is available for the index rebuild process and for the other processes that will need TEMP tablespace, during the time the index_rebuild process is running.