Comments

To use reorg rebuild, you must be the table owner or the database owner, or have system administrator privileges.

If you omit the index or partition name, the entire table is rebuilt.

If you specify an index, only that index is rebuilt. Similarly, if you specify an index partition, only that index partition is rebuilt.

Requirements for using reorg rebuild on an index are less stringent than for tables. The following rules apply: