You must first run the analyze table com-mand

536 Part III ✦ Administering Storage for Oracle Objects

TABLE_NAME CHAIN_CNT------------------------------ ----------TEST_MIG 0

After you have moved a table, all indexes on the table will need to be rebuilt

SQL> SELECT CLASSID,COURSENUMBER
2 FROM STUDENT.SCHEDULEDCLASSES
3 WHERE CLASSID = 50;

SELECT *
*
ERROR at line 1:

SQL> SELECT CLASSID,COURSENUMBER
2 FROM STUDENT.SCHEDULEDCLASSES
3 WHERE CLASSID = 50;

CLASSID COURSENUMBER
---------- ------------
100

From time to time, DBAs may need to deallocate space from a table because too much space was initially allocated or maybe because the nature of the table has changed. The estimated data volume may not be what it was expected, and the DBA wants to use the space allocated for the table for other tables. The DBA is limited to deallocating space above the high-water mark only unless the entire table is being rebuilt.

Table analyzed.

SQL> SELECT TABLE_NAME, BLOCKS, EMPTY_BLOCKS 2 FROM DBA_TABLES
3 WHERE TABLE_NAME=’TEST_MIG’;