oracle找出大于1g的表,表占用太大空间问题！

做的測試如下：

SQL> conn tpeter/tpeteroracle;

Connected.

SQL> @?/rdbms/admin/utlchain.sql

Table created.

SQL> ANALYZE TABLE A LIST CHAINED ROWS INTO chained_rows;

ANA

Table analyzed.

SQL> LYZE TABLE B LIST CHAINED ROWS INTO chained_rows;

ANA

Table analyzed.

SQL> LYZE TABLE T LIST CHAINED ROWS INTO chained_rows;

A

Table analyzed.

SQL> NALYZE TABLE T_F LIST CHAINED ROWS INTO chained_rows;

A

Table analyzed.

SQL> NALYZE TABLE T_P LIST CHAINED ROWS INTO chained_rows;

ANALYZE TABL

Table analyzed.

SQL> E T_PARTITION_HASH LIST CHAINED ROWS INTO chained_rows;

AN

Table analyzed.

SQL> ALYZE TABLE T_PARTITION_HASH2 LIST CHAINED ROWS INTO chained_rows;

AN

Table analyzed.

SQL> ALYZE TABLE T_PARTITION_LIST LIST CHAINED ROWS INTO chained_rows;

ANALY

Table analyzed.

SQL> ZE TABLE T_PARTITION_RANGE LIST CHAINED ROWS INTO chained_rows;

ANALYZE TABLE T_PARTITION_

Table analyzed.

SQL> RH LIST CHAINED ROWS INTO chained_rows;

Table analyzed.

SQL> SELECT table_name, count(*) from chained_rows GROUP BY table_name;

no rows selected

SQL> SELECT name, value FROM v$sysstat WHERE name = 'table fetch continued row';

NAME                                                                  VALUE

---------------------------------------------------------------- ----------

table fetch continued row                                               153

運行的兩個語句的查詢一個有行遷移一個沒有這是怎麼回事？