All Products
Search
Document Center

ApsaraDB for OceanBase:Subpartitioning

Last Updated:Mar 17, 2023

This topic describes the conversion scope of CREATE TABLE DDL operations for defining subpartitions during data migration from an Oracle database to an Oracle tenant of OceanBase Database.

RANGE subpartitioning

Syntax of subpartition_by_range:

SUBPARTITION BY RANGE ( column [, column]... ) [subpartition_template]

Supported operations

  • Defining RANGE subpartitions by using the SUBPARTITION BY RANGE ( column [, column]... ) option is supported.

  • Defining subpartition templates by using the subpartition_template option is supported. For more information, see Subpartition templates.

LIST subpartitioning

Syntax of subpartition_by_list:

SUBPARTITION BY LIST ( column [, column]... ) [ subpartition_template ]

Supported operations

  • Defining LIST subpartitions by using the SUBPARTITION BY LIST ( column [, column]... ) option is supported.

  • Defining subpartition templates by using the subpartition_template option is supported. For more information, see Subpartition templates.

HASH subpartitioning

Syntax of subpartition_by_hash:

SUBPARTITION BY HASH (column [, column ]...)
   [ SUBPARTITIONS integer
        [ STORE IN (tablespace [, tablespace ]...) ]
   | subpartition_template
   ]

Supported operations

  • Defining HASH subpartitions by using the SUBPARTITION BY HASH ( column [, column]... ) option is supported.

  • Defining subpartition templates by using the subpartition_template option is supported. For more information, see Subpartition templates.

Unsupported operations

Specifying tablespaces by using the STORE IN (tablespace [, tablespace ]...) option is not supported. This option will be ignored.