Overview for creating partitions

This topic describes the conversion scope of CREATE TABLE DDL operations for partition synchronization during data migration from an Oracle database to the Oracle compatible mode of OceanBase Database.

Syntax

{ range_partitions
| list_partitions
| hash_partitions
| composite_range_partitions
| composite_list_partitions
| composite_hash_partitions
| reference_partitioning
| system_partitioning
| consistent_hash_partitions
| consistent_hash_with_subpartitions
| partitionset_clauses
}

reference_partitioning:
PARTITION BY REFERENCE ( constraint ) 
  [ (reference_partition_desc...) ]

system_partitioning:
PARTITION BY SYSTEM [ PARTITIONS integer
                    | reference_partition_desc
                       [, reference_partition_desc ...]
                    ]

consistent_hash_partitions:
PARTITION BY CONSISTENT HASH (column [, column ]...)
  [ PARTITIONS AUTO ] TABLESPACE SET tablespace_set

consistent_hash_with_subpartitions:
PARTITION BY CONSISTENT HASH (column [, column ]...)
  { subpartition_by_range
  | subpartition_by_list
  | subpartition_by_hash
  }
  [ PARTITIONS AUTO ]

partitionset_clauses:
{ range_partitionset_clause | list_partitionset_clause }

Supported operations

• Defining RANGE partitions by using the range_partitions clause is supported. For more information, see RANGE partitioning.

• Defining LIST partitions by using the list_partitions clause is supported. For more information, see LIST partitioning.

• Defining HASH partitions by using the hash_partitions clause is supported. For more information, see HASH partitioning.

• Defining RANGE subpartitions by using the composite_range_partitions clause is supported. For more information, see RANGE subpartitioning.

• Defining LIST subpartitions by using the composite_list_partitions clause is supported. For more information, see LIST subpartitioning.

• Defining HASH subpartitions by using the composite_hash_partitions clause is supported. For more information, see HASH subpartitioning.

Unsupported operations

• Reference partitioning reference_partitioning is not supported. An error will be returned when you perform this operation.

• System partitioning system_partitioning is not supported. An error will be returned when you perform this operation.

• Creating consistent HASH partitions consistent_hash_partitions is not supported. An error will be returned when you perform this operation on non-sharded tables. This clause can only be used for sharded tables.

• Creating HASH partitions consistent with subpartitions by using the consistent_hash_with_subpartitions clause is not supported. An error will be returned when you perform this operation on non-sharded tables. This clause can only be used for sharded tables.

• Using the partitionset_clauses clause to create RANGE and LIST partition sets is not supported. An error will be returned when you perform this operation.