Optimizing Storage Structures - Oracle Database 11gR2 Performance Tuning - page 80

8. Move the table BIG_ROWS to the tablespace just created:

ALTER TABLE HR.BIG_ROWS MOVE TABLESPACE TS_16K;

9. Rebuild the indexes, as they are unusable after the move:

ALTER INDEX HR.PK_BIG_ROWS REBUILD;

10. Analyze the table to refresh the statistics:
ANALYZE TABLE HR.BIG_ROWS COMPUTE STATISTICS;

11. Verify if there are chained rows.
SELECT CHAIN_CNT FROM ALL_TABLES
WHERE OWNER = ‹HR› AND TABLE_NAME = ‹BIG_ROWS›;

12. In the next screenshot, we can see the results of these operations:

13. Drop the tablespace and the table:
DROP TABLESPACE TS_16K INCLUDING CONTENTS AND DATAFILES;