This topic describes the conversion scope of CREATE TABLE DDL operations for defining composite partitions during data migration from an Oracle database to an Oracle tenant of OceanBase Database.
RANGE composite partitioning
Syntax of composite_range_partitions
:
PARTITION BY RANGE ( column [, column]... )
[ INTERVAL ( expr ) [ STORE IN ( tablespace [, tablespace]... ) ]]
{ subpartition_by_range
| subpartition_by_list
| subpartition_by_hash
}
( range_partition_desc [, range_partition_desc ]... )
Defining a partition as a RANGE partition is supported. For more information, see RANGE partitioning. Defining RANGE, LIST, and HASH subpartitions by using the
subpartition_by_range
,subpartition_by_list
, andsubpartition_by_hash
options is supported. For more information, see Subpartitioning.Defining RANGE partitions by using the
range_partition_desc
option is supported. For more information, see User-defined partitions.Specifying partition intervals and namespaces by using the
INTERVAL
andSTORE IN
options is not supported. These options will be ignored.
LIST composite partitioning
Syntax of composite_list_partitions
:
PARTITION BY LIST ( column [, column]... )
[ AUTOMATIC [ STORE IN ( tablespace [, tablespace ]... ) ] ]
{ subpartition_by_range
| subpartition_by_list
| subpartition_by_hash
}
( list_partition_desc [, list_partition_desc]... )
Defining a partition as a LIST partition is supported. For more information, see LIST partitioning. Defining RANGE, LIST, and HASH subpartitions by using the
subpartition_by_range
,subpartition_by_list
, andsubpartition_by_hash
options is supported. For more information, see Subpartitioning.Defining LIST partitions by using the
list_partition_desc
option is supported. For more information, see User-defined partitions.Automatically creating LIST partitions and specifying tablespaces by using the
AUTOMATIC
andSTORE IN
options are not supported. These options will be ignored.
HASH composite partitioning
Syntax of composite_hash_partitions
:
PARTITION BY HASH (column [, column ] ...)
{ subpartition_by_range
| subpartition_by_list
| subpartition_by_hash
}
{ individual_hash_partitions
| hash_partitions_by_quantity
}
Defining a partition as a HASH partition is supported. For more information, see HASH partitioning. Defining RANGE, LIST, and HASH subpartitions by using the subpartition_by_range
, subpartition_by_list
, and subpartition_by_hash
options is supported. For more information, see Subpartitioning.