This topic describes the conversion scope of CREATE TABLE DDL operations for defining subpartitions during data migration from an Oracle database to an Oracle-compatible 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.