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_templateoption 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_templateoption 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_templateoption 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.