重建索引表空间

 

 【原创】重建索引表空间

第一步：创建索引表空间

CREATE TABLESPACE " PES_IDX" LOGGING DATAFILE '/opt/oracle/oradata/pes/ PES_IDX.dbf' SIZE 10240M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO;

 

第二步：通过系统表DBA_INDEXES检索出所有指定用户的索引，通过"ALTER INDEX   index_name  REBUILD TABLESPACE   index_space_name"命令重建索引表空间

BEGIN
    FOR c IN (SELECT 'ALTER INDEX '|| t.index_name || ' REBUILD TABLESPACE   PES_IDX' AS v_sql  FROM Dba_Indexes t WHERE owner =   'PES') LOOP
        EXECUTE IMMEDIATE c.v_sql;
    END LOOP;
END;
/