ER.IDX_ID_OXXXDX_MX
ON OXX_XXT_OWNER.ID_OXXXDX_MX (OXG_NO,
IXX_CODE,
……
SXPPLY_TYPE,
DXTA_SRC)
TABLESPACE TBS_XXN_DT
LOCAL;
CREATE INDEX OXX_XXT_OWNER.IDX_ID_OXXXDX_MX2
ON OXX_XXT_OWNER.ID_OXXXDX_MX (STAT_XXCLE)
TABLESPACE TBS_XXN_DT
LOCAL;
CREATE INDEX OXX_XXT_OWNER.IDX_ID_OXXXDX_MX3
ON OXX_XXT_OWNER.ID_OXXXDX_MX (OXG_NO, STAT_XXCLE)
TABLESPACE TBS_XXN_DT
LOCAL;
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'
若返回结果不为空 则说明执行成功。