Several maintenance operations require room to make a copy of the data pages of a table:
create clustered index
alter table...lock
Some alter table commands that add or modify columns
reorg rebuild on a table
In most cases, these commands also require space to re-create any indexes, so you need to determine:
The size of the table and its indexes
The amount of space available on the segment where the table is stored
The space management properties set for the table and its indexes
The following sections describe tools that provide information on space usage and space availability.
