nothing is changing.Code:SQL> ALTER TABLE TEST.TEST move storage (minextents 1); Table altered. Elapsed: 00:00:00.04 SQL> SELECT tablespace_name "Tablespace Name", 2 bytes/1048576 "Size(M)" 3 FROM dba_segments 4 where owner='TEST'; Tablespace Name Size(M ------------------------------------------------------------------------------------------ --------- TEST_DATA 100.5 TEST_DATA 48.5 TEST_DATA 56.5 Elapsed: 00:00:00.01 SQL> analyze table TEST compute statistics; Table analyzed. Elapsed: 00:00:00.00 SQL> SELECT tablespace_name "Tablespace Name", 2 bytes/1048576 "Size(M)" 3 FROM dba_segments 4 where owner='TEST'; Tablespace Name Size(M ------------------------------------------------------------------------------------------ --------- TEST_DATA 100.5 TEST_DATA 48.5 TEST_DATA 56.5 Elapsed: 00:00:00.01 SQL>




Reply With Quote