分裂全局分区索引

不能直接分裂局部索引分区，只有在分裂分区表时才能分裂局部索引分区。但是可以直接分裂全局索引分区。

示例：分裂全局分区索引

--  清理环境
DROP INDEX pti;
DROP TABLE tab;
DROP TABLESPACE ts1;
DROP TABLESPACE ts2;

--  创建表空间
CREATE TABLESPACE ts1 DATAFILE 'ts1.dt' SIZE 5M AUTOEXTEND ON NEXT 5M;
CREATE TABLESPACE ts2 DATAFILE 'ts2.dt' SIZE 5M AUTOEXTEND ON NEXT 5M;

CREATE TABLE tab
( 
    id NUMERIC(6),
    time_id DATE
);

-- 创建全局分区索引
CREATE INDEX pti ON tab(id)
GLOBAL PARTITION BY RANGE(id)
( 
    PARTITION p_10 VALUES LESS THAN (10),
    PARTITION p_20 VALUES LESS THAN (20),
    PARTITION p_others VALUES LESS THAN (maxvalue)
);

ALTER INDEX pti SPLIT
PARTITION P_10 AT (5) INTO
( 
    PARTITION P_10_1 TABLESPACE ts1,
    PARTITION p_10_2 TABLESPACE ts2
);

--  删除表和表空间
DROP INDEX pti;
DROP TABLE tab CASCADE;
DROP TABLESPACE ts1;
DROP TABLESPACE ts2;