針對遞增欄位(如 ID)作為分區鍵的範圍分區測試流程:
CREATE TABLESPACE test01 DATAFILE '...' SIZE 50M;
CREATE TABLESPACE test02 DATAFILE '...' SIZE 50M;
CREATE TABLESPACE test03 DATAFILE '...' SIZE 50M;
CREATE TABLESPACE test_idx01 DATAFILE '...' SIZE 20M;
CREATE TABLESPACE test_idx02 DATAFILE '...' SIZE 20M;
CREATE TABLESPACE test_idx03 DATAFILE '...' SIZE 20M;
CREATE TABLE test (
aa INTEGER,
bb VARCHAR2(100)
)
PARTITION BY RANGE (aa) (
PARTITION part_01 VALUES LESS THAN (10000) TABLESPACE test_idx01,
PARTITION part_02 VALUES LESS THAN (30000) TABLESPACE test_idx02,
PARTITION part_03 VALUES LESS THAN (MAXVALUE) TABLESPACE test_idx03
);
CREATE INDEX idx_test_aa ON test(aa) LOCAL (
PARTITION part_01 TABLESPACE test_idx01,
PARTITION part_02 TABLESPACE test_idx02,
PARTITION part_03 TABLESPACE test_idx03
);
CREATE SEQUENCE seq_test_aa MINVALUE 1 MAXVALUE 60000 START WITH 1 INCREMENT BY 1 CACHE 10;
EXP 匯出ALTER TABLE test DROP PARTITION part_03;ALTER TABLE test ADD PARTITION part_03 VALUES LESS THAN (MAXVALUE) TABLESPACE test03;IMP 導入資料回分區DELETE、再 INSERT 驗證ALTER TABLE test SPLIT PARTITION part_02 AT (50000) INTO (PARTITION part_02, PARTITION part_06 TABLESPACE test01p2);分區命名建議從 part_01、part_02 開始,預留擴充空間,便於後續 SPLIT 操作插入新分區。