结合全局分区索引

示例：结合全局分区索引

--  清理环境
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 HASH(id) PARTITIONS 3;

ALTER INDEX pti COALESCE PARTITION;

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