4.5. 重新统计表及索引信息

BEGIN

DBMS_STATS.gather_table_stats (ownname => 'OXX_XXT_OWNER',

tabname => 'ID_OXXXDX_MX',

estimate_percent => 20,

degree => 8,

cascade => TRUE);

END;

/

4.6. 开启行迁移

ALTER TABLE OXX_XXT_OWNER.ID_OXXXDX_MX ENABLE ROW MOVEMENT;

5. 验证

执行如下sql语句：

SELECT *

FROM dba_tab_partitions

WHERE table_owner = 'OXX_XXT_OWNER' AND table_name = 'ID_OXXXDX_MX'

若返回结果不为空 则说明执行成功。