ApsaraDB for OceanBase (Deprecated):Template Subpartisi

Sintaksis subpartition_template:

SUBPARTITION TEMPLATE
  ( { range_subpartition_desc [, range_subpartition_desc] ...
    | list_subpartition_desc [, list_subpartition_desc] ...
    | individual_hash_subparts [, individual_hash_subparts] ...
    }
  ) | hash_subpartition_quantity

Pendefinisian template subpartisi menggunakan kata kunci SUBPARTITION TEMPLATE didukung. Sintaksis dalam template ini sama dengan partisi yang didefinisikan pengguna. Untuk informasi lebih lanjut, lihat Partisi yang didefinisikan pengguna. Contoh kode:

CREATE TABLE 
T (C1 DATE, C2 NUMBER)PARTITION BY RANGE (C1) SUBPARTITION BY RANGE (C2)
SUBPARTITION TEMPLATE 
(SUBPARTITION SP_TEMP VALUES LESS THAN (999))
(
  PARTITION SALES_Q1_1998 VALUES LESS THAN (TO_DATE('01-APR-1998','DD-MON-YYYY', 'NLS_DATE_LANGUAGE=AMERICAN')),
  PARTITION SALES_Q3_1999 VALUES LESS THAN (TO_DATE('01-OCT-1999','DD-MON-YYYY', 'NLS_DATE_LANGUAGE=AMERICAN')),
  PARTITION SALES_Q2_2000 VALUES LESS THAN (TO_DATE('01-JUL-2000','DD-MON-YYYY', 'NLS_DATE_LANGUAGE=AMERICAN')),
  PARTITION SALES_Q3_2000 VALUES LESS THAN (TO_DATE('01-OCT-2000','DD-MON-YYYY', 'NLS_DATE_LANGUAGE=AMERICAN')),
  PARTITION SALES_Q4_2000 VALUES LESS THAN (MAXVALUE)
  );